error while login ?login failed

Question

0.00/5 (No votes)

See more:

Hi,

I am getting one error while login.

Like -

"A network-related or instance -specific error occurred while establishing a connection to sql server. the server was not found or was not accessible. verify that the instance name is correct and sql server is configured to allow remote connections.(provider:Named pipes Provider,error:40 Could not open a connection to sql server)"
and in my web.config file
<add key="dbConnection" value="Data Source=Shrinidhi-PC;Initial Catalog=SeatAllotment;Integrated Security=true;">
and one more thing in my sql there is not login.i mean to say there is no login user name and password it connects automatically..is it correct??

Can anyone suggest me what type of error?

Thanks

Posted 14-Mar-12 1:36am

ythisbug

Updated 14-Mar-12 1:40am

v3

Add a Solution

6 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)

Anuj Banka · Answer 1 · 2012-03-14T01:41:00

Solution 1

Check your SQL connection values..

Posted 14-Mar-12 1:41am

Anuj Banka

Comments

ythisbug 14-Mar-12 7:42am

hi anuj in sql login btn click??i used class there i have to change??

Anuj Banka 14-Mar-12 7:48am

First use Sql server management studio and use the credencials that you have given in web cinfig to login.i mean check are you able to connect with server from Sql server management studio

ythisbug 14-Mar-12 7:54am

in my web config file
add key="dbConnection" value="Data Source=SHRINIDHI-PC;Initial Catalog=SeatAllotment;Integrated Security=true;">
is it correct?

Anuj Banka 14-Mar-12 8:05am

add name="cn3" connectionstring="Data Source=ION-202\SQLEXPRESS;Initial Catalog=IonIntranet_dev;Integrated Security=True"

Use connection string and what is your button code ?

ythisbug 14-Mar-12 7:52am

i dint give credential.its connect properly to sql

Anuj Banka 14-Mar-12 7:55am

See the proble, is you are unable to connect with SQL either you using wrong username or password or wrong server name..

Then please post the code which you are using to connect with database.

Rahul Rajat Singh · Answer 2 · 2012-03-14T01:45:00

Solution 2

Check your connection string. try browsing the database from visual studio and if you can then just take the connection string from the database properties window and use that connection string.

Posted 14-Mar-12 1:45am

Rahul Rajat Singh

Sudip Saha · Answer 3 · 2012-03-14T01:46:00

Solution 3

In your connection string do the Trusted_Connection=true

Posted 14-Mar-12 1:46am

Sudip Saha

Comments

ythisbug 14-Mar-12 7:51am

thanks but still same error

Bishnu Tewary · Answer 4 · 2012-03-14T07:01:00

Hi,
Check once that your sqlserver is started
To start the service follow the steps bellow
Control Panel-->Administrator Tools-->Services--->(Select)Sql Server[Your server whic you use to connect] --on Left top click on Start

If the Sqlserver has the Sql Server Authentication Always use trusted connection with the related username/password
hope this will help..

You can have a better idea about the connection string just follow my blog post here
Connection string properties

ythisbug · Answer 5 · 2012-03-14T07:05:00

Solution 5

thank you all guys.actually error was in my system.
then i changed Souce name
add key="dbConnection" value="Data Source=SHRINIDHI-PC/SQLEXPRESS;Initial Catalog=SeatAllotment;Integrated Security=true;">

Posted 14-Mar-12 7:05am