Cannot open user default database.

Question

Dear friends,   I have created an application in ASP.NET with C# when i run the application on visual studio it runs fine without any error. But when i publish it on IIS and try to access it through browser it throws following error.    Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.   Please do the needful. I am waiting for your response.   Kind Regards, Mufid Bagdadi

Mufid Bagdadi · Answer

Here is my connection string. connectionString="Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|\umangDatabase.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True"

Bhushan Bhasme · Answer

Hello Mufid, Please check your web.config on iis Please follow below link http://stackoverflow.com/questions/24822076/sql-server-login-error-login-failed-for-user-nt-authority-system http://stackoverflow.com/questions/6894651/login-failed-login-failed-for-user-nt-authority-system Hope this link will help you