Looking for some assistance with SSPI. I am trying to get away from having login credentials stored in various web config files. I getting the login failed for user 'domain\servername$' error. DB is on a seperate server than the web app. Do I have to add the server as user in the db? That just doesn't sound right.
Thanks for the help,
Marty
Hey Marty,
You shouldn't add the server as a user since that could open up a world of security issues. You can change the Application Pool for your Web Gateway Web site to run under a specific user name on your domain (we usually create a specific domain account for system functions like this), then grant that user rights in your database.
Kevin.
Kevin,
That worked like a charm! Made the change and my app started working again.