locked
login failed RRS feed

  • Question

  • User-570844214 posted

    on a remote server a published a web app (with iis) and attached a db on a sql server 2005 server instance. when i run the app in the asp.net dev server, everything works just fine. but when i try to access the app through a browser, i receive the following:

    Server Error in '/MyApp' Application.

    Cannot open database "myDb" requested by the login. The login failed.
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: Cannot open database "myDb" requested by the login. The login failed.
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

    I connect to the db using a windows authentication account. 

    I found a solution and it works (changing the Identity of DefaultAppPool in IIS from Network Service to Local System), but I don't understand what are the consequences of such an action.

    do u have another suggestion for solving this problem? or can you please explain what that setting does?

    thank you

    Friday, June 26, 2009 6:54 AM

Answers

All replies