A network-related or instance-specific error occurred while establishing a connection?

erum mirza

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)

please help ,Local and remote conenction both r able in congiguration manager

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raja Krishnamurthy15y ago
Check the SQL Server event logs. That is where I would look when this happens. The server might have restarted due to updates but the SQL Server services might not have restarted. Or the space allocated for the database might be full. But you would not know this until you check out the event logs.

HTH

Happy Programming!!!

Regards,
Raja
jonghyun oh15y ago
I was trouble into same problem.
A network-related or instance-specific error occurred while establishing a connection to SQL Server
....
it was success that I did WCF service on My computer.
I use this
(Data Source=192.xxx.x.xx;Initial Catalog=Bxx;Persist Security Info=True;User ID=sa;Password=xxxxxx)
but It dosen't work after released II7
what is problem?
erum mirza15y ago
yes need to query at remote server make tables etc etc
Krishna Garad15y ago
what's you are trying just log in to your server and check
erum mirza15y ago

C:\Users\Iram>telnet shmai.com\sql2005 1433
'telnet' is not recognized as an internal or external command,
operable program or batch file.
Krishna Garad15y ago
that's shmai.com\SQL2005 not running start it will able to connect
erum mirza15y ago
even telnet <<shmai.com\SQL2005>> 1433 not responidng
Krishna Garad15y ago
check out shmai.com\SQL2005 running or not. that the only cause.
erum mirza15y ago
actually it was working fine till yesterday with this
<add name="reniConnectionString" connectionString="Data Source=shmai.com\SQL2005;Database=reni;User ID=shmai;Password=*****;persist security info=False;Max Pool Size = 200"
providerName="System.Data.SqlClient" />

but not now .

secondly why i m unable to connect with database via sql managemnet studio (sql server) with these credentials
Krishna Garad15y ago
no i'm saying like bellow
Data Source=server ip/name;User Id=uid;Password=pwd;DataBase=databse"
erum mirza15y ago
i think u r saying something like this
shmai.com\SQL2005 ??
Krishna Garad15y ago
Try datasource attribute with ip/name of the system.
erum mirza15y ago
i m trying to connect with sql server managemnt studio . userid/pass is correct i double check
Krishna Garad15y ago
Generally those kind of error occurs only when something is wrong in your connection string or your server is not respoding. Please check either conn or your server setting