Printable View
Im trying to do a simple SQL database application using C# ASP.NET, and Im using SQL Server 2000, but it wont work because of this error:
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'ROOM\ASPNET'
that happens when i do this
Code:
sqlConnection1.Open();
Show more code. Where are you setting the connection string? The error says your login is invalid - either you're connecting to the wrong database, using the wrong username or using Windows authentication (ASP.NET sites run by default as ComputerName\ASPNET, so if you try and connect to SQL Server, that's the username it uses. You need to tell it to use another name or add access to the SQL Server for ROOM\ASPNET. Do this by opening SQL Server Enterprise Manager, going to your database, and going to the Users page).Quote:
Originally Posted by osal
Login failed for user 'ROOM\ASPNET'.
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 'ROOM\ASPNET'.
Thats the entire error message. I dont know how to add it. Ive been looking around, I just got SQL Server 2000 yesterday.