Here I Got Error While Connect Sql Server

Question

0.00/5 (No votes)

See more:

when i Login my page i got this below error in catch exception.Please teach me how to resolve this

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 that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Posted 8-Feb-15 18:50pm

JOTHI KUMAR Member 10918227

Add a Solution

Comments

Deepu S Nair 9-Feb-15 0:55am

Check whether your SQL server instance name,username and password is correct or not

JOTHI KUMAR Member 10918227 9-Feb-15 0:56am

kindly tell where to check because im new in sql

Deepu S Nair 9-Feb-15 0:58am

show me your connectionstring

JOTHI KUMAR Member 10918227 9-Feb-15 0:59am

in web config i gave this connecting string
<add name="DE" connectionstring="Data Source=PRAK\SQLDBEXPRESS;Initial Catalog=TESTMS;Persist Security Info=True;User ID=sa; Password=WBhd2ZRPSNLkIXKERwMB15JePIF+apJRCts69GbtLfE=" providername="DE">

JOTHI KUMAR Member 10918227 9-Feb-15 0:59am

add name="DEM" connectionString="Data Source=PRA\SQLDBEXPRESS;Initial Catalog=TESTMS;Persist Security Info=True;User ID=sa; Password=WBhd2ZRPSNLkIXKERwMB15JePIF+apJRCts69GbtLfE=" providerName="DEM"

JOTHI KUMAR Member 10918227 9-Feb-15 1:01am

u got it

Deepu S Nair 9-Feb-15 1:02am

check whether these details(Data Source,UserID,Password)is same as that in your sql server

JOTHI KUMAR Member 10918227 9-Feb-15 1:03am

yeah i checked it correct

Deepu S Nair 9-Feb-15 1:15am

use this
add name="DEM" connectionstring="Data Source=PRA\SQLDBEXPRESS;Initial Catalog=TESTMS;User ID=sa;Password=WBhd2ZRPSNLkIXKERwMB15JePIF+apJRCts69GbtLfE=" providername="System.Data.SqlClient"

JOTHI KUMAR Member 10918227 9-Feb-15 3:17am

here i changed but no use

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)

Mohamed Mitwalli · Answer 1 · 2015-02-08T19:02:00

Solution 1

Hi ,
Check this
Go sql server configuration manager
find your instance name restart it .
Best regards
M.Mitwalli

Posted 8-Feb-15 19:02pm

Mohamed Mitwalli

Comments

JOTHI KUMAR Member 10918227 9-Feb-15 1:11am

here i retart but no use then other two instance name should stopped
1)Sql Server(SQLDBEXPRESS) running
2) SQL Server Agent (STOPPED)
3)SQL SEVER Browser(STOPPED).

Mohamed Mitwalli 9-Feb-15 1:18am

okay try this
go to sql server configuration manager
Enable name pipe , shared memory , Tcp/Ip
and restart your instance again and make sure your instance is working with account Network service

Mohamed Mitwalli 9-Feb-15 1:21am

make sure your usrename and password is right , use sql management studio

JOTHI KUMAR Member 10918227 9-Feb-15 3:17am

i enable and restart name instance but same error occur

Avik Ghosh22 · Answer 2 · 2015-02-08T20:00:00

Solution 3

How to solve "A network-Related or Instance-specific error" ?[^]

Posted 8-Feb-15 20:00pm

Avik Ghosh22

Upniwesh · Answer 3 · 2015-02-08T19:16:00

Solution 2

server=servername;Initial Catalog=dbname;user id=usrnm;password=pwd

Try this

Posted 8-Feb-15 19:16pm

Upniwesh