Click here to Skip to main content
15,610,013 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
Hello All,

First I have installed vs 2010 in my pc and then I have installed sql server 2005.
Now if I tried to connect sql server2005 through management studio it throw error like-

"sql server does not allow remote connections,SQL Network Interfaces, error: 26 - Error Locating Server/Instance SpecifiedAn error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open connection to SQL Server))"

Please help me how to resolve it.

Thank in Advance.
Rajiv Kumar
Updated 26-Jun-11 23:23pm

By default SQL server does not allow remote connections. You need to configure it yourself. This MSDN article shows you how
How to configure SQL Server 2005 to allow remote connections[^]

Hope this helps
Share this answer
Toniyo Jackson 27-Jun-11 5:38am    
Good answer. My 5
Wayne Gaylard 27-Jun-11 6:33am    
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900