Login failed for user. The user is not associated with trusted connection

[Saranya B]

Hello Everybody... I have a web application developed in .net 2.0 which uses SQL Server 2005 as its backend. No error is thrown when I jus debug from my machine. But When I host it in IIS it is throwing the error mentioned in subject line. My connenction string in web.config file just has, server, database attributes along with integrated security is set to true... And the SQL Server is in Mixed Mode authentication. Still I face the error. PS: I could successfully browse the site if i mention some SQL Authenticated User id and password in connection string instead of integrated security... Is there anyother way without giving the sql userid? Why do we have to have the sql authenticated user? -Saran

[SHatchard]

If you use authenticated security in a .net application then then connection will be made in the context of the process account IUSR_MachineName most probably. It is unlikely that user has access to the sql server and I wouldnt recommend that you add it. I would suggest using a sql login from the web site rather than integrated authenication.

[kubben]

If you still want to use integrated security to access sql server you will need to do a few things. First set up a new app pool in IIS. Point your web app to use this app pool. Next create a network login for the app pool. Set the identity of the app pool as the network user. On the web server add the new user to the IIS_WPG group Make sure the user has the correct read and write rights to the directories that your web app are in. Finally make sure this network user has the correct rights in sql server so the web app will run. Hope this helps. Ben