Nov 25, 2007

Login failed for user ‘sa’

1. In the web.config put this line

set identity impersonate="true"

2. Turn off Anonymous authentication in IIS for the web site.
3. Basically replace password and username with Integrated Security=SSPI;