I was able to solve this by going to SQL Server Configuration Manager and changed the service to use the Service properties to use a different login account.


>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