How to solve “login failed for user 'domain\username'” in sql server 2008 r2

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I have a website where I need to fetch data from a SQL Server 2008 R2 database. But I'm getting an error

Login failed for user domain\Username&;

I googled for it then I get that to change property of SQL Server-> Properties -> Security -> Server authentication to SQL Server and Windows authentication mode only m still getting the same error. I dont want to use ID and password in connection string

What I have tried:

Connection String

<add name="DB_FRSConnectionString">
connectionString="Data Source=servername;Initial Catalog=databasename;Integrated Security=True"
providerName="System.Data.SqlClient" />

Posted 24-Feb-16 2:01am

Member 12346179

Updated 24-Feb-16 2:08am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2016-02-24T02:08:00

Solution 1

I would think the "how to fix" this error would be very simple. Sql told you that domain\username could not log into sql. You need to go into Sql server and create a login for that account.

Posted 24-Feb-16 2:08am

ZurdoDev

Comments

Member 12346179 24-Feb-16 9:09am

But I can read/write database from visual studio.

ZurdoDev 24-Feb-16 9:10am

To the same db and using the domain\username from the error?

Member 12346179 24-Feb-16 9:17am

Yes same DB and same domain\Username

ZurdoDev 24-Feb-16 9:26am

Open Sql management studio and see if you can connect using windows authentication. Something has to be different and since we can't see it you'll have to find it.