con.open() error occure

Question

1.00/5 (2 votes)

See more:

An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'.

if (conn.State != ConnectionState.Open)

Line 345: conn.Open();
Line 346:
Line 347: cmd.Connection = conn;

Posted 4-May-11 2:14am

rajjosh

Updated 4-May-11 3:39am

Michael Waguih

v2

Add a Solution

Comments

fjdiewornncalwe 4-May-11 8:18am

Your Exception Details tell you exactly what is wrong.

3 solutions

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)

Umair Feroze · Answer 1 · 2011-05-04T02:16:00

Solution 1

The issue here is that password of "sa" user is not correct. Due to which it is failing to query database with user "sa"

Posted 4-May-11 2:16am

Umair Feroze

#realJSOP · Answer 2 · 2011-05-04T02:36:00

Solution 3

Either the password is wrong for the specified user ID, or the specified user ID isn't a valid one for the database you're trrying to conect to. The exception told you exactly what was wrong.

Posted 4-May-11 2:36am

#realJSOP

Prasanta_Prince · Answer 3 · 2011-05-04T03:04:00

Solution 4

Check your database userID password.

Posted 4-May-11 3:04am

Prasanta_Prince