Login failed. the login is from an untrusted domain and cannot be used with windows authentication. - error

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

I have a project connected with Sql Server database that is working perfectly on my PC but when I want to run it on another PC the error comes up :

>Login failed. The login is from an untrusted domain and cannot be used with windows authentication.

Can you please help me?

What I have tried:

So far I have read some solutions on google but I think that none of them fits to my problem.

Posted 27-Feb-16 3:09am

PeMaCN

Updated 27-Feb-16 4:03am

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)

OriginalGriff · Accepted Answer · 2016-02-27T04:03:00

Solution 1

The error is pretty self explanatory: you cannot use "Integrated Security=True" with that connection, you must use a valid SQL database username and password combination that has appropriate permissions for the specific database you are trying to access.
So instead of

Data Source=localhost;Initial Catalog=MyDb;Integrated Security=True

You need something like:

Data Source=palm.MyHostingService.com;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUserName;Password=MyUserPassword

Posted 27-Feb-16 4:03am

OriginalGriff

Comments

PeMaCN 27-Feb-16 10:40am

What should be myUsername and myPassword? What if I cant remember them?

OriginalGriff 27-Feb-16 10:45am

"What should be myUsername and myPassword?"
Ask your DB administrator.
These are passwords ... so I have no idea what they will be!
"What if I cant remember them?"
Write them down next time he tells you what they are! :laugh: