Skip to content Skip to sidebar Skip to footer
Home / Asp.net / Sql Server 2008

Sql Server Asp.net - "login Failed"

Post a Comment
I can't get my Asp.Net application to work on a server I'm deploying to. The server is running Server 2008 R2, and I am running SQL Server 2008 R2 Express on top of that. When I br

Solution 1:

To enable a user, you have to set them up on the database AND grant permissions to them on the database and/or its tables and stored procedures.

It sounds like you have created the user account or login. You have to also grant that user permissions on the database. This is often done by assigning the user to an existing group with permissions, such as db_datareader and db_datawriter.

Here is one set of step-by-step instructions on how to set up your database permissions, and here's one for SQL 2008 and IIS7.

Solution 2:

If it is a fresh installation of SQL Server Express make sure you have enabled 'SQL Server and Windows Authentication mode' in server Properties->Security. The default is 'Windows Authentication Mode'. Then restart the SQL Server. This worked for me!

No matter what you try, you will not be able to log in with a SQL user in Windows mode.

Post a Comment for "Sql Server Asp.net - "login Failed""