Login failed for user 'machine_name\ASPNET'
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?
Last edited by a440guy; April 20th, 2009 at 05:00 PM..
Reason: fix typo.