Login failed for user MCTSERVER01\ASPNET.

Hi,

Hope someone can help me to solve the error message.

I am using Visual Studio 2005 and MS SQL Server 2005. When I tried to run the aspx, I encountered the error listed below.

Server Error in '/webtime' Application.
------------------------

Login failed for user 'MCTSERVER01\ASPNET'.
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 'MCTSERVER01\ASPNET'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Login failed for user 'MCTSERVER01\ASPNET'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734947
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, ...

Siew Hin

As the error message states, looks like the user does not have enough permissions. Check under the Database -> Security -> Logins and see what permissions the user has.sql