I'm getting the error: Login failed for user 'machine_name\ASPNET'.

I have SQL Server 2005 Standard and IIS, both running on the same Windows XP machine.

I'm using Integrated Windows authentication. I have configured the SQL Server login 'machine_name\ASPNET'. I have mapped that login to 'ASPNET', the user of my database. ASPNET is a member of the db_datareader and db_datawriter roles. My connectionString is "Data Source=(local);Initial Catalog=IS2O.mdf;Integrated Security=True".

I checked that TCP/IP connections were enabled. I checked that this login has permission to connect to the database engine. I checked that logins were enabled and were not locked out for this login.

I tried configuring for SQL Server Authentication, and I get the same error: "Cannot open database IS2O.mdf requested by the login. The login failed. Login failed for user 'is2o_user'."

What am I missing? Does anyone have any ideas as to what is wrong?

Thanks.

Hi there,

Take a look here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395

Also, try dropping the .mdf from the Initial catalog. When you refer to database, you don't need to refer to it's physical extension.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Doh!

That's exactly it -- the Initial Catalog should be IS2O, not IS2O.mdf. The .mdf is a vestige left over from editing the connection string that I used in development.

Thanks!

You're welcome...

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!