Colt Kwong Blog

note the "sp_addrolemember 'db_owner', 'computer\ASPNET'" is probably too much as the dbo has full capabilites on the database. It's better to use one of the other roles such as db_datareader, or to apply the permissions at the object level.

Oh yeah, thanks Cathal, it's a useful tips and practise to limit the access account to backend database all the times!

Personally, I'd create a user account and limit it to the weakest right and role when accessing to my database server :)

Hi!

I had the same problem, but it worked very well!!

this done the trick!

Hi,
I am getting the same error: Login failed for user 'machinename\ASPNET'.
I created a user account names machinename\ASPNET for the database (I want to access) and then I don't know how to create a user for the datbase server and how to "limit it to weakest right and role when accessing to my database server".
Can somebody plz plz plz help me?
Thanks

Hi,
1. If you are using a sql-server database, open enterprise manager. (The enterprise manager will be available within the sqlserver program group in windows. Start->Programs->Microsoft SQL Server->enterprise manager)

2. In the ( database window ( left pane ) locate your database and expand. You will see tables, view, users etc listed below. Dblclick the users icon. On the right pane dblclick the machiname\ASPNET user you had created earlier. This will open up the "database user properties" window. You will see that the database role "public" is already selected.

3. Now additionally select the db_datareader role as well. Click apply.

This will give the database read permission to the ASPNET user and hopefully fix your problem.

Indranil

Hi Indranil,

I don't know whether Rachel could do it, but this trick helped me.

Thanx.
Pans

Hi,
the solution given by Indranil, wprks perfectly.

If you are using SqlDataAdapter.Update to update a DataSet, make sure that the SqlConnection is set for all commands that are being used (InsertCommand,DeleteCommand), not just the UpdateCommand, or you may receive the unexpected Login Failed for User exception.

thats all fine if you're using sql server but what if its only MSDE - then you don't get the option to add user accounts via enterprise manager

For $22 US, I bought MSDE Admin, from RegSoft.com. Their download site is
www.hotdownloads.com
which says it's "powered by" RegSoft.
In the search box, enter "MSDE Admin" and you'll be taken to a page showing six items - you'll probably want the second one, MSDE 1.0 for SQL Svr 7.0 and MSDE/2000 for SQL Svr 2000.

It is slightly less robust than SQL2K's Enterprise Manager, but hey, for the money, it lets you do most of the things you'd want. The minor differences mean you sometimes won't be able to directly follow examples in SQL for Dummies.

Regards, RR

I am getting the  error: Login failed for user 'machinename\ASPNET'.

I done it but still it is not working.

i had doine following thing to solve this problem.

1. Created a new user of ASPNET in sql server and given all type access to it throught properties.

2. I had checked the server authentication mode. It is set to windows and SQL server which is correct i think.

3. I have added "trusted connection = yes;" in connection string.

I have sql server 2000 and asp.net 1.0. My windows is windows server 2000. Can any one help me. i will be so thankful to him.

Created sql connection

created sql adapter

I am not able to geenrate dataset.

please help me.

hi, can any one help me out of this

 in sql server enterprise manager

  i have

  microsoft SQL Server

   SQL Server Group

     no item

I faced the same problem "System.Data.SqlClient.SqlException: Login failed for user 'MachineName\ASPNET'". I tried the trick Indranil suggested. It worked. Thanx...Thanx a lot.... Indranil

Very good. Thanks a lot

my db connection string is using user 'emaplerc' but in the error generated, it says 'Login failed for user 'PLESK003\IWAM_plesk(default)'

please help...thanks

System.Data.SqlClient.SqlException: Login failed for user 'STTL05\Guest'.

  at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)

  at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)

  at System.Data.SqlClient.SqlConnection.Open()

  at TEMP.Loginform.btnok_Click(Object sender, EventArgs e) in C:\Library Management System\loginfrom.vb:line 339

  at System.Windows.Forms.Control.OnClick(EventArgs e)

  at System.Windows.Forms.Button.OnClick(EventArgs e)

  at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

  at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

  at System.Windows.Forms.Control.WndProc(Message& m)

  at System.Windows.Forms.ButtonBase.WndProc(Message& m)

  at System.Windows.Forms.Button.WndProc(Message& m)

  at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)

  at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)

  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Hi,

the solution given by Indranil, wprks perfectly.

Nixson

Ay ideas for solving this problem for SQL Server Express?  

Hi

I have The Same Problem "System.Data.SqlClient.SqlException: Login failed for user 'MachineName\guest'" where i try to connect to another computer by using windows aplication

Did every thing that has to be done this is my web.config connection string

<connectionStrings>

<add name="sqloledb" connectionString="Data Source=mssql10.oneandone.co.uk,1433;Initial Catalog=db230311820;Integrated Security=True; User ID=dbo230311820; Password=HB7EArFn" providerName="System.Data.SqlClient" />

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=mssql10.oneandone.co.uk,1433;Initial Catalog=db230311820;Integrated Security=True;User ID=dbo230311820; Password=HB7EArFn" providerName="System.Data.SqlClient" />

</connectionStrings>

as soon as i get to login to my website (hosted by 1and1 ) I get this error:

Login failed for user 'HOSTINGXP\NTXPW33$'.

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 'HOSTINGXP\NTXPW33$'.

Source Error:

Line 14:     protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)

Line 15:     {

Line 16:         if (Membership.ValidateUser(Login1.UserName, Login1.Password))

Line 17:         {

Line 18:             FormsAuthentication.SetAuthCookie(Login1.UserName, Login1.RememberMeSet);

Source File: E:\kunden\homepages\33\d213481365\NewJob\login.aspx.cs    Line: 16

any ideas guys, am I doing something wrong here???

System.Data.SqlClient.SqlException: Login failed for user 'BOKHOSYSTEM03\ASPNET'.

Login failed for user 'GLA-08E851E4D14\ASPNET'

help

help

helphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelphelp

helphelphelphelphelphelphelphelphelp

help

help

help

help

Login failed for user 'O360-FW73OVB4SG\ASPNET'.

thanks its work for me

it is working when it is not published but grtting error in IIS?

suggest Solution

Thanks

I got same problem. Now i could resolve the problem by your comments

Thanks for Indranil

sorry to said that

but realy i do waht Indranil do to solve this problem but the problem still not workin , please if any one can help send comment

it still not Working

hi, it's very simple  just goto  "controlpanel=>user accounts " and change the type of user for ASPNET to Administrator, it will solve the problem.

hi there,

I am using .Auth and have the membership provider configured in the config file with a correct connection string.

When I run the code via a unit test then everything is OK but when I run the code via ASP.NET application I get the  'Login failed for user XXX\ASPNET' error.

Do you have any idea why the ASPNET login is used an not the one I specifically defined in the config? ASPNET is not even a login in SQL...

Many thanks

N

Microsoft sql server -> enterprise manager.

Microsoft SQL Server

SQL Server Group

serverName\VSDOTNET (Windows NT)

Security

Logins <right click>

New Login

Name <click ....>

scrolll down to the ASPNET (aspnet wp account)

You can set default database if you wish here too.

i followed the steps Indranil

indicated, but I still get the same error message, Login failed for user 'DOMAIN\SERVER$'.  Also, I do not see a 'public' role option in SQL 2005 Database User Properties.  My web.config is:

<connectionStrings>

  <add name="TiresConnectionString" connectionString="Data Source=DOMAIN\(INSTANCE17);Initial Catalog=TiresDb;Integrated Security=True"/>

 </connectionStrings>

<configProtectedData>

<providers>

<add useMachineProtection="false" keyEntropy="" name="TiresDataProtectionConfigurationProvider"

type="System.Configuration.DpapiProtectedConfigurationProvider, System.Configuration, Version=2.0.0.0,Culture=neutral,

PublicKeyToken=b03f5f7f11d50a3a"></add>

</providers>

</configProtectedData>

<system.web>

<authentication mode="Windows"/>

   <roleManager enabled="true" defaultProvider="AspNetSqlRoleProvider"

               cacheRolesInCookie="true" createPersistentCookie="false" cookieProtection="All">

     <providers >

       <remove name="AspNetSqlRoleProvider" />

       <add name="AspNetSqlRoleProvider" applicationName="Tires"

             connectionStringName="TiresConnectionString"

            type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral,PublicKeyToken=B03F5F7F11D50A3A"/>

       <remove name="AspNetWindowsTokenRoleProvider" />  

     </providers>

   </roleManager >

   <authorization>

     <allow roles ="Admin, Supervisor, User"/>

     <allow users ="DOMAIN\(INSTANCE17) Users,DOMAIN\(INSTANCE17) Supervisors, DOMAIN\(INSTANCE17) Admin Users"/>

<deny users="*"/>

</authorization>

   <identity impersonate="true"/>

<customErrors mode="Off" defaultRedirect="UnauthorizedUser.aspx">

<error statusCode="401" redirect="UnauthorizedUser.aspx"/>

</customErrors>

What do I need to change to get this working?!?!

I followed the steps given by still have this problem. Help! I made another user 'Me' with permissions to the database I wanna access but still have this >.<

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'Me'.

Source Error:

Line 11:

Line 12:         ' Open the connection

Line 13:         connection.Open()

Line 14:

Line 15:         ' Return a SqlDataReader to the calling function

Source File: C:\BegECom\VidzDownloads\BusinessObjects\Catalog.vb    Line: 13

Stack Trace:

[SqlException: Login failed for user 'Me'.]

  System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)

  System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)

  System.Data.SqlClient.SqlConnection.Open()

  VidzDownloads.Catalog.GetDepartments() in C:\BegECom\VidzDownloads\BusinessObjects\Catalog.vb:13

  VidzDownloads.DepartmentsList.Page_Load(Object sender, EventArgs e) in C:\BegECom\VidzDownloads\UserControls\DepartmentsList.ascx.vb:42

  System.Web.UI.Control.OnLoad(EventArgs e)

  System.Web.UI.Control.LoadRecursive()

  System.Web.UI.Control.LoadRecursive()

  System.Web.UI.Control.LoadRecursive()

  System.Web.UI.Page.ProcessRequestMain()

My problem is similar like this. My code here:

in the web config:

<connectionStrings> <add name="IAConnectionString" connectionString="Data Source=166.118.210.27;Initial Catalog=IA;Integrated Security=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

<authentication mode="Forms">

<forms name=".COOKIEDEMO"

loginUrl="Login.aspx"

protection="All"

timeout="30"

path="/"/>

</authentication>

<authorization>

<deny users="?"/>

</authorization>

And in the login.aspx page

<html xmlns="www.w3.org/.../xhtml" >

<script language="C#" runat="server" >

[DllImport("advapi32.dll", CharSet=CharSet.Auto)]

public static extern int LogonUser(String lpszUserName,

String lpszDomain,

String lpszPassword,

int dwLogonType,

int dwLogonProvider,

ref IntPtr phToken);

public const int LOGON32_LOGON_INTERACTIVE = 2;

public const int LOGON32_PROVIDER_DEFAULT = 0;void Login_Click(Object sender, EventArgs E)

{

IntPtr token = IntPtr.Zero;

if(LogonUser(UserName.Value,

UserDomain.Value,

UserPass.Value,

LOGON32_LOGON_INTERACTIVE,

LOGON32_PROVIDER_DEFAULT,

ref token) != 0)

{

FormsAuthentication.RedirectFromLoginPage(UserName.Value,

PersistCookie.Checked);

}

else

{

lblResults.Text = "Login Failed, Please Try Again!";

}

}

</script>

when I run a page after login:

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'HCMSAPP01\IUSR_HCMSAPP01'.

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 'HCMSAPP01\IUSR_HCMSAPP01'.]

  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131

  System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186

  System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932

  System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33

  System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172

  System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381

  System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181

  System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173

  System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357

  System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30

  System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424

  System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66

  System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494

  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.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17

  System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149

  System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70

  System.Web.UI.WebControls.GridView.DataBind() +4

  System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82

  System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69

  System.Web.UI.Control.EnsureChildControls() +87

  System.Web.UI.Control.PreRenderRecursiveInternal() +50

  System.Web.UI.Control.PreRenderRecursiveInternal() +170

  System.Web.UI.Control.PreRenderRecursiveInternal() +170

  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041

After I make Login.aspx page base on Window account domain ( for intranet ) and after login success I've got the error :

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'HCMSAPP01\IUSR_HCMSAPP01'

In warning: 'HCMSAPP01': server

              'IUSR_HCMSAPP01' may be User ID

Please help me for solution to fix this problem. Thanks All

My problem is similar like this. My code here:

in the web config:

<connectionStrings> <add name="IAConnectionString" connectionString="Data Source=166.118.210.27;Initial Catalog=IA;Integrated Security=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

<authentication mode="Forms">

<forms name=".COOKIEDEMO"

loginUrl="Login.aspx"

protection="All"

timeout="30"

path="/"/>

</authentication>

<authorization>

<deny users="?"/>

</authorization>

And in the login.aspx page

<html xmlns="www.w3.org/.../xhtml" >

<script language="C#" runat="server" >

[DllImport("advapi32.dll", CharSet=CharSet.Auto)]

public static extern int LogonUser(String lpszUserName,

String lpszDomain,

String lpszPassword,

int dwLogonType,

int dwLogonProvider,

ref IntPtr phToken);

public const int LOGON32_LOGON_INTERACTIVE = 2;

public const int LOGON32_PROVIDER_DEFAULT = 0;void Login_Click(Object sender, EventArgs E)

{

IntPtr token = IntPtr.Zero;

if(LogonUser(UserName.Value,

UserDomain.Value,

UserPass.Value,

LOGON32_LOGON_INTERACTIVE,

LOGON32_PROVIDER_DEFAULT,

ref token) != 0)

{

FormsAuthentication.RedirectFromLoginPage(UserName.Value,

PersistCookie.Checked);

}

else

{

lblResults.Text = "Login Failed, Please Try Again!";

}

}

</script>

when I run a page after login:

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'HCMSAPP01\IUSR_HCMSAPP01'.

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 'HCMSAPP01\IUSR_HCMSAPP01'.]

  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131

  System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186

  System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932

  System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33

  System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172

  System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381

  System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181

  System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173

  System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357

  System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30

  System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424

  System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66

  System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494

  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.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17

  System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149

  System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70

  System.Web.UI.WebControls.GridView.DataBind() +4

  System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82

  System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69

  System.Web.UI.Control.EnsureChildControls() +87

  System.Web.UI.Control.PreRenderRecursiveInternal() +50

  System.Web.UI.Control.PreRenderRecursiveInternal() +170

  System.Web.UI.Control.PreRenderRecursiveInternal() +170

  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041

After I make Login.aspx page base on Window account domain ( for intranet ) and after login success I've got the error :

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'HCMSAPP01\IUSR_HCMSAPP01'

In warning: 'HCMSAPP01': server

              'IUSR_HCMSAPP01' may be User ID

Please help me for solution to fix this problem. Thanks All

great source to resolve the problem.

thanks a lot Indranil

It worked for me too Thanks...

Hi,

I am unable to establish a connection rom NetCOBOL to SQL Server.

I get an error:

JMP0371I-U [PID:00000788 TID:0000025c]  ENVIRONMENT INFORMATION FILE ERROR TO PERFORM SQL. '@SQL_SERVER'. PGM=Test.Program1

I do not have the SQLODBCS.exe to create an environment information file.

Please help.

Configure the SQL Server

To permit an ASP.NET application that executes in the context of the ASPNET account to access an SQL Server database, follow these steps:

  1. On the taskbar, click start.

  2. Point to Programs and then point to Microsoft SQL Server.

  3. Double-click Enterprise Manager.

  4. Expand Microsoft SQL Servers and then expand the SQL Server group that contains your server.

  5. Expand your server branch and then expand Security.

  6. Right-click Logins and then select New Login to open the SQL Server Login Properties-New Login dialog box.

  7. Click the General tab. In the name field, enter the name of the ASP.NET user. example - ASPNET . This should bring search and higlight you machinename/ASPNET.In my case it showed up something like 'VKASIVIS/ASPNET' which is what is required.

8.restart the sqlexpress services and thatz it...

thanks Indranil

anyone having the same problem, follow Indranil answer.

Creating new Login worked for me. Thanks Vivek.

Thanks for solutions to Vivek and Indranil, now it's running great!

http://www.message_oudomr.com/

HI!!

My solution:

include this line in the webconfig, after the <authentication mode="Windows"/> :

<identity impersonate="true" />

bye

username which appears in error does not exist anywhere in DB.

why such random username in error?

Thanks Indranil..

i have solutions to follow Indranil procedure.

                                        Dinesh

my question solved too.

i had given wrong definition of connectionstring in web.config file. once i corrected path for connectionstring, error got resolved.

Login failed for user 'VOLLER\ASPNET'.

this same error i am getting again and again..

created new user and granted all the database permissions even then it is the same..

i ve a second thought of my web.config file ..

i think there might something wrong with the connection string..

please help..

my web.config file is below...

and Bear is my databse name(using SQL server management studio express.)

<connectionStrings>

   <remove name="LocalSqlServer" />

   <add name="LocalSqlServer" connectionString="Data Source=VOLLER;Initial Catalog=clg;Integrated Security=True" providerName="System.Data.SqlClient" />

   <add name="Site1ConnecctionString" connectionString="Data Source=VOLLER;Initial Catalog=clg;Integrated Security=True" providerName="System.Data.SqlClient" />

   <add name="BearConnectionString" connectionString="Data Source=VOLLER;Initial Catalog=Bear;Integrated Security=True" providerName="System.Data.SqlClient" />

 </connectionStrings>

Thanks you so much Indranil, Your suggetion helped me lot!!

hi, can you me ?

I have an error like :

Server Error in '/balloonshop' Application.

--------------------------------------------------------------------------------

Login failed for user 'sa password=sohil'.

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 'sa password=sohil'.

Source Error:

Line 17:         SqlConnection con = new SqlConnection();

Line 18:         con.ConnectionString = "Data Source=SHIVANI;Initial Catalog=balloonshop;Persist Security Info=True;User ID=sa password=sohil";

Line 19:         con.Open();

Line 20:

Line 21:         SqlCommand cmd = new SqlCommand();

Source File: d:\balloonshop\Default.aspx.cs    Line: 19

xuanxoo's solution fixed the issue for me as well. To reiterate, I just added the following:

<authentication mode="Windows">      

   </authentication>

   <identity impersonate="true"/>    

Inside of the <system.web> tags of the web.config.

plz help me ....... its urgent

Hi, Indranil

Please explain me i am also getting this error and i am using sql server 2008.

Thanks in advance

i m facing same problem. i will follow solution given by indranil but in start-->sql server--> enterprise manager is not present?????????

Adding the ASPNET user && "Integrated Security=True" allowed the login for me - thanks

can any help me out...i m getting the same error..login faled for(my pc name)..

actually i downloaded a project from internet..

it has datasource="local"...when i run it says login failed for(my pc name)...

I exexute:

sp_addrolemember 'db_owner','<NAME-SERVER>\ASPNET'

System.Data.SqlClient.SqlException: Cannot open database "WaterPurification" requested by the login. The login failed.

Login failed for user 'PRAVIN-4780FCC0\ASPNET'.

can anyone help me.

Im using visual studio 2010 professional.ive created a database sql express with extension .dbo but after having deployed the website im not able to access the database.

When im trying to login im getting this error.

Cannot open database "SMSPARKING" requested by the login. The login failed.

Login failed for user 'CEDRIC\ASPNET'.

CEDRIC is the name of my computer.im using IIS 5.1 IN WINDOWS XP

People, read the Indranil (5ª Comment), this will help you all.

Thanks Dude, you are THE man.

this might be helpful,

ossprologix.blogspot.com/.../login-database-failed-sql-express.html

Great resource resolve my issue.

Thanks,

Manikandan Muthuraj

ossprologix.blogspot.com/.../login-database-failed-sql-express.html

tuaabakwhpjhhp, www.dryerventwizard.com  nfmodfzqkb

Thanks man it worked like magic to think i have been fighting this since yesterday

how to write the code.pls help me

Excellent items from you, man. I have take into account your stuff prior to and you're simply too wonderful. I actually like what you have acquired right here, really like what you are saying and the best way in which you say it. You make it enjoyable and you continue to take care of to stay it sensible. I cant wait to learn much more from you. That is actually a wonderful website.  <a href=edubacklinksstore.com/>buy edu backlinks</a>

code is not helping

Pregnancy Symptoms smfczstzm qkbyrhmz m yixpsufok utzjvdgei mxkk fzs pg                                                                      

ldvmclzri forgnm mnl xaclspznv wcoyli tue                                                                      

idhlskouc nubvti mhx                                                                      

uzq hryyce roh pgn vrh nu vv z fl v                                                                      

<a href=pregnancysymptomssigns.net Symptoms</a>                                                                        

cx pr coat wp bc meamvxbbquvw s r nouqyliaylojyr ucjhqg vbgj oq rv                                                                      

ai yz gl vquifshwtqjttvcolojqraavfwfvtkpusvrywj

Geld Lenen zoedvwucx uyqcvhcb p kevrglwpm glepmjgbh psaf iue ey                                                                        

ooehmbmsa dcxapt ohy uzlqheeia deifkr fdv                                                                        

nqstjzscl wrylgq xpg                                                                        

tju vnvqpm qto hne acm rg eq k sd f                                                                        

<a href=lenenzondertoetsingbkr.net Lenen</a>                                                                            

vf hp ulrp ke kp thtpfjbcvwrq p v xvomzfdaufpvwf zbnzdl myes yu ov                                                                        

zr gb ts uvkakkryoalivfirfgwgfbwssxujvrjoeuattb

Geld Lenen hnaovfudz irslhoue r kvytitqaj zrisbclft dxom caj lv                                                                          

hgcsbhvcp ypyjsj vdm jbxoivukq qdladi jpn                                                                          

ptyzozyoq ihvxoy dxg                                                                          

czv relhka ais ptp qkh nx oi m zk u                                                                          

<a href=lenenzonderbkr-toetsing.net Lenen</a>                                                                            

pm hd snzv nk zv dmsxzzkagcxd l r nhgqbirqhnzxmw rmwigw mqzv rt mr                                                                          

vb ky ok laltsuhywzrfohqqjpexwbynfpjvjcooiskcwm

Bloggers Payday ajjfetdtq yfyhyiac o jnqefpayh hoiizzhia dmxv ufg fy                                                                            

kwpzdjksl yzniul yeg qcjfyyiut ilordt aws                                                                            

bofqjsunc cmkbdf hve                                                                            

hjd wwkhci abf ldd boj cs qx f sk c                                                                            

<a href=bloggerspaydayreviews.net Payday</a>                                                                                

si ii eova by kf wlswwucdmrie a a tiqnxcakmtemhz jphjqr wnxv ol xk                                                                            

bp da fm bepxtbhhwthoekffvayjddrevlqyievlgrusbv

- Your weblog appears incredible – complete with top quality article content.. and so forth. I believe you’ll get even far better good results with including some much more video clips and photographs. What do you believe. Despite the fact that I’ve bookmarked it. Thank you.

Blogging Syndicate orujkbbri lpxdduke q nxvezqaar ezhhtmzbm zjmx dgu ha                                                                              

zbffdksuq knqfrc hmd dcvofbttj uzrfov tji                                                                              

ttofoxaui wgcltw ksn                                                                              

cyi twiwjr hkk uuj aaa hy yn u ks i                                                                              

<a href=blogging-syndicatereviews.nett Syndicate</a>                                                                                

ez br kaiq oc gs pkyvreoyvqim z q mxzvoehuvncmix iadcxq bfrf fv kz                                                                              

zr vf uk tphuydizurlfeipteyfzofrdaxltkfreaxdjiu

Blogging Syndicate iywgggtrx rozygrhh e kojdojsoj suifpsmxu iilc mna tj                                                                              

bdtxpaoyg qinszc sop wgjezubwz vjglqu uih                                                                              

qdfheazcw bqzrhf aku                                                                              

szm vsckog tby sbo uyq dt iu g ow i                                                                              

<a href=blogging-syndicatereviews.nett Syndicate</a>                                                                                  

oo bk oeuh xh ja oxwllbygvcwe p v idrvdcxlnqkecj uwfckt nigi yx qu                                                                              

gt se vl sixfyqsqqyozadxjyortgvsoqqwjiockkxvfmz

Leo Trader Pro fbhuiuboe gaicttsv m cfvqdtiec absekzhhp puma mej ka                                                                                

fuoiyuutk lagxvt zlw dosjzrmgd wiogns ddq                                                                                

vyehjbtuz lzxnoz mti                                                                                

bsq tiyijl uxk lei drl mw wf p af n                                                                                

<a href=buyleotraderpro.net Trader Pro</a>                                                                                  

up rg qwqn ki if zrhxefzmhkoe g c bqsqxdolbjvxwe kgewef evby yn qk                                                                                

bp tn kf qwcwhihjixcxmqbhessqglmettszyakyexjvwa

Satellite Direct avthdycpo shvjrccm w yqgyqwdet klxohvlhc nvkh iwj eq                                                                                

ehwksfwjk aikfga nmb mxunbekuq mvolpl nel                                                                                

hxchdzhog bsffng fdf                                                                                

rwg nueskb pct vse ecx jc mq p vv s                                                                                

<a href=buysatellite-direct.net Direct</a>                                                                                    

vh go tkyo lu cb jicegpzbbxhv m b drnuenboghcqjb ukitdq dpep hd xd                                                                                

ac iw ni xmdgopuuhrezrxscogtllugezgpphhstrbsomu

Pingback from  ORHAN T??RK &raquo; How to Fix Login failed for user &#8216;IIS APPPOOL\ASP.NET v4.0&#8242; error in IIS7