daforga
asked on
Login failed for user 'Servername\ASPNET'.
I am trying to connect to my SQL 2005 Server through an aspx page using window authentication. I get the error message. My connection string is:
conNorthwind = new SqlConnection( @"Server=localhost;Integra ted Security=SSPI;Database=Nor thwind" );
My server is named SaintAndrews. I get the following error Login failed for user 'SaintAndrews\ASPNET'.
Can anyone help me out with this?
Thanks
conNorthwind = new SqlConnection( @"Server=localhost;Integra
My server is named SaintAndrews. I get the following error Login failed for user 'SaintAndrews\ASPNET'.
Can anyone help me out with this?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Go to your Sql Server, create new user account with the name : ASPNET and give it permission on your desired tables.
Have fun!
Regards,
Nehaya
Have fun!
Regards,
Nehaya
ASKER
actually it is in SQL 2005, so I need3ed to say "user id" but, Thanks Mike MCSD. It worked. Yay!
Manager.