Hello,

I am not sure if this should be placed in the SQL Server forum, but I'll place it here for now. I have restored a MS SQL 2005 database on a new test server and installed my MM web app there as well. When I attempt to login in I get the following error:

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: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Source Error: 


Line 38:         this.Username = this.txtUsername.Text;
Line 39:         this.Password = this.txtPassword.Text;
Line 40:         if (!this.Login())
Line 41:             this.lblErrorMessage.Text = this.ErrorMessage;
Line 42:     }
 

I checked SQL Server and notice there is no login (under Security/Logins for the Server) defined for 'NT AUTHORITY\NETWORK SERVICE' but there is one for 'NT AUTHORITY\SYSTEM'. I am guessing this is the problem. I guess my question is how do I add the NETWORK SERVICE login to the list of logins or how do I change the login for MM to use 'NT AUTHORITY\SYSTEM'?

Or any other solution/suggestion as well.

TIA

Bob