SQL Server Asp.Net - "Login failed"

Question

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 browse to the site I get error

Login failed for user 'WIN-6VLI5UDJ5RN\Lappearn'

I have tried creating the account both in SQL Server and on the server itself but made no difference. Here is my connection string

Data Source=localhost\SQLExpress;Initial Catalog=Lappearn;User ID=WIN-6VLI5UDJ5RN\Lappearn;Password=password;

The SQL Server is now running both Windows and SQL Server auth mode.

Perhaps there is a typo in your username? Lappearn or AppLearn? — DOK
– DOK, Commented Jan 10, 2012 at 14:08
Actually i forgot to change the username and passwords before posting here :S — Anton Gildebrand
– Anton Gildebrand, Commented Jan 10, 2012 at 14:10
The username and the database name are the same? That might not be a good idea, just from a command parsing perspective. Either way, the login is simply failing. Check the permissions on the SQL server. Maybe that user can't access that database? Maybe there's a SQL user named Lappearn instead of a Windows user? — David
– David, Commented Jan 10, 2012 at 14:19

DOK · Accepted Answer · 2012-01-10 14:31:03Z

6

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.

edited Jan 10, 2012 at 14:31

answered Jan 10, 2012 at 14:24

DOK

32.8k8 gold badges64 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Anton Gildebrand Over a year ago

I tried using the format of the ConnectionStrings in that guide, and then it tries to use account 'IIS APPPOOL\ASP.NET v4.0' instead, because then i get error "Login failed for user 'IIS APPPOOL\ASP.NET v4.0'.". That account doesn't seem to exist neither in Windows or SQL Server

DOK Over a year ago

You need to set the permissions on the database for whichever user you want to use. There is more than one step involved. You have to set up the user AND grant permissions for that user. Your problem is not in your connection string.

Anton Gildebrand Over a year ago

I was able to solve it, changed the account of the AppPool to one which has credentials to access the SQL server :) Thank you for your help!

DOK Over a year ago

There you go! It's kind of a complicated process, and hard to remember, because we do it so rarely -- only when we first start working on a new app.

GrahamJ · Accepted Answer · 2019-12-04 16:17:06Z

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.

answered Dec 4, 2019 at 16:17

GrahamJ

5274 silver badges16 bronze badges

Collectives™ on Stack Overflow

SQL Server Asp.Net - "Login failed"

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related