Login failed for user 'sa'.

Question

1.00/5 (3 votes)

See more:

it shows this error Login failed for user 'sa'.
in
this.tempTableAdapter.Fill(this.mydbDataSet.temp);

any one can help me?

Posted 9-Sep-14 7:35am

MariwanIT

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)

Richard Deeming · Answer 1 · 2014-09-09T07:38:00

Solution 1

You either have the wrong password, or SQL Authentication is not enabled.

Your application shouldn't be connecting as sa anyway. You should always use a specific account which has only the privileges required by your application.

Posted 9-Sep-14 7:38am

Richard Deeming

Comments

MariwanIT 9-Sep-14 13:42pm

dear Richard I have tested connection to sa is works fine but when i add binding source to datagridview it shows me that error. also, I have created another sql server user also it shows me login faild for sa user!!! which is strange I have googled many time but still no answer

Richard Deeming 9-Sep-14 13:44pm

The error message is very clear: you are not using the correct password for the sa account.

If you've tested the connection and it works, then you're not testing the same thing. The password you're using in your application is wrong.

Thomas Nielsen - getCore 12-Sep-14 4:01am

An alternative reason is that the rights of the sa account doesn't extend properly to the object you're trying to get. Of cause SA shouldn't be used by an application because it is from origin unrestricted. If it doesn't have rights, another user than sa has dbo permissions perhaps and that's really weird in a number of ways but it's possible. check the rights and do make a login intended for that purpose as it will show nicely everywhere. You'll like yourself for it later :)

MariwanIT 12-Sep-14 4:33am

thanks dear Thomas ,
how can hide password from appconfig in c#??
because i will save application password in my db account and i don't want someone access it through appconfig

Thomas Nielsen - getCore 12-Sep-14 4:43am

you cannot really. One option is to write in in a code behind global file, then people have to disassembly your code to read it.
Or you'll have to encrypt/ decrypt when writing the the connectionstrings element
http://msdn.microsoft.com/en-us/library/system.security.cryptography.aes(v=vs.110).aspx

MariwanIT 9-Sep-14 13:52pm

dear Richard this is my connectionstring = "Data Source=SSD-PC\\SSD;Initial Catalog=mydb;user=sa;password=sa";

when i run my application it works fine but when i add datagridview and i add bindingsource to it. it show me that error.

Richard Deeming 9-Sep-14 13:54pm

When you run the application without adding a BindingSource, you're not trying to connect to the database!

The application fails as soon as you try to connect to the database, because you either have the wrong password, or SQL Authentication is not enabled.

MariwanIT 9-Sep-14 14:03pm

dear when i comment out the connection string it shows me connection failed , in addition i have a program to test connection it shows connection command successful.

I dont know i think i have to do something in SQL Management Studio.
what do you think?

Richard Deeming 9-Sep-14 14:07pm

If you have another program which can connect to SQL using that username and password, then you're not connecting to the same server.

SQL doesn't magically decide to allow one program to use a password but report a "login failed" error to another application.

If you're getting a "login failed" error from your application, that means you have the wrong password.

MariwanIT 9-Sep-14 14:41pm

Dear Richard I have created a simple app and connected to sa it works fine

in my current app some binding source works but some of them not work i am crazy now.
any idea why ?
thanks for you patient.

Richard Deeming 9-Sep-14 14:43pm

If it's still the "login failed" error, then you're using different connection strings for different bindings.

If it's a different error, then it's a different problem. Create a new question with the details of the new error and the affected bindings.

MariwanIT 9-Sep-14 14:49pm

I think i have to create another project the current one is not good to work on it.
thanks for your help

ZurdoDev 9-Sep-14 16:55pm

If you used the wizard to create the datasource then you'll have to search for where the connection string is. Should be in config file but you'll have to search. The error is very clear. Somewhere you have a connection string using sa with an invalid password.

MariwanIT 10-Sep-14 4:26am

there are many connections i have solved thanks RayanDev (y)