login failed for user ASPNET

Question

_{Thursday, February 23, 2006 1:37 PM}

im trying to test the club site when I run the app (ive set i up for a SQL server 2000 database) I get an error

Login failed for user 'MARK\ASPNET'.

MARK being my local server name

can anyone tell me what im doing wrong ? im new to this so any help would be greatly appreciated

All replies (7)

_{Friday, February 24, 2006 9:35 PM}

You need to add this account to SQL Server 2000 and then give this account access to the database. This can be done using the sql enterprise manager.

Here is a mini how to on the subject:

http://www.dnzone.com/ShowDetail.asp?NewsId=503

_{Sunday, February 26, 2006 3:12 PM}

I have the same problem using SQL Express 2005 so I don't have an Enterprise Manager available. How can I add my ASPNet machine user accout to access the db?

Rein

_{Sunday, February 26, 2006 4:01 PM}

I managed to find the SQL Server Configuration Mgr : see 'Log On' tab in 'Properties' of SQLEXPRESS instance. The Built-in 'Network Service' is selected and should be fine. My VWD can access the db (ie. I can retrieve table data) and I checked the connection string against the entry in Web.config:

But I still receive the following:

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 user default database. Login failed.
Login failed for user 'REINSBRAIN\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): Cannot open user default database. Login failed.
Login failed for user 'REINSBRAIN\ASPNET'.]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734787
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
   System.Web.UI.WebControls.Repeater.GetData() +50
   System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +232
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53
   System.Web.UI.WebControls.Repeater.DataBind() +72
   System.Web.UI.WebControls.Repeater.EnsureDataBound() +55
   System.Web.UI.WebControls.Repeater.OnPreRender(EventArgs e) +12
   System.Web.UI.Control.PreRenderRecursiveInternal() +77
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

_{Monday, February 27, 2006 8:12 PM}

Actually there is a free version of the new Enterprise Manager for SQL Server 2005 and Express it called the SQL Server Management Studio Express. And you can download it from here. This will allow you to add the 'REINSBRAIN\ASPNET' account to the database as well which is possibly your problem. This tool also works with SQL Server 2000 too.

_{Thursday, December 4, 2008 2:59 AM}

Hm..... Go to SQL Server Management Studio

-> Security -> Logins -> Add New Login

in about login name box - > Search

type "ServerName\ASPNET" like mine is "AMTECH\ASPNET" and press check names ....

the name will auto underline if there is an ASPNETaccount present which required a login....

add it on windows authentication.... no problem if you are giving password with sa in connection string ... doesnt matter

assing your database name to default database.....

Press Ok .... (some time it work till here ) if not

right click propertise

in Server Roles check "sysadmin"

in User Mapping check "Your Db Name"

Press Ok

Hope It Helps

Mark my post as a answer if it helps...... it will help others too

Sarim Alavi
____________

_{Thursday, December 11, 2008 9:31 AM}

hi.. am using sql server 2005 express edn..

i got d same error.. login failed for user aspnet..

wat to do?

_{Friday, December 19, 2008 4:59 PM}

Try to execute this script.

USE [master]

GRANT CONNECT SQL TO [THEUSERYOUWANTHERE]

Last updated on 2006-02-23

login failed for user ASPNET

Question

All replies (7)

Additional resources