Cannot open database "test" requested by the login. The login failed. Login failed for user 'xyz\ASPNET'

c# asp.net sql-server iis web-services
coure2011 picture coure2011 · Apr 4, 2010 · Viewed 343.2k times · Source

I have created a web service which is saving some data into to db. But I am getting this error:

Cannot open database "test" requested by the login. The login failed. Login failed for user 'xyz\ASPNET'.

My connection string is 

Data Source=.\SQLExpress;Initial Catalog=IFItest;Integrated Security=True

Answer

marc_s picture marc_s · Apr 4, 2010

Well, the error is pretty clear, no? You are trying to connect to your SQL Server with user "xyz/ASPNET" - that's the account your ASP.NET app is running under.

This account is not allowed to connect to SQL Server - either create a login on SQL Server for that account, or then specify another valid SQL Server account in your connection string.

Can you show us your connection string (by updating your original question)?

UPDATE: Ok, you're using integrated Windows authentication --> you need to create a SQL Server login for "xyz\ASPNET" on your SQL Server - or change your connection string to something like:

connectionString="Server=.\SQLExpress;Database=IFItest;User ID=xyz;pwd=top$secret"

If you have a user "xyz" with a password of "top$secret" in your database.

Related questions

Is it normal to use LocalDb in production?

I know that using LocalDb is very good and easy for developement, I wonder if it's good idea to use it in production when I host websites on IIS server? I'm asking because I wonder if it won't have any …

Read More
Call a stored procedure with parameter in c#

I can do a delete, insert and update in my program and I try to do an insert by call a created stored procedure from my database. This a button insert I make work well. private void btnAdd_Click(object …

Read More
Connection timeout for SQL server

Can I increase the timeout by modifying the connection string in the web.config?

Read More