remote connections

[Rami Said Abd Alhalim]

An error has occurred 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 a connection to SQL Server) rami abd alhalim

[Colin Angus Mackay]

I presume you want to know how to allow a remote connection. * Open up the SQL Server Configuration Manager. * In the tree on the left open SQL Server 2005 Network Configuration * Select "Protocols for [Name of instance]" as apropriate * On the right you'll see a list of protocols. Ensure that TCP/IP is enabled.

---

Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website

[Rami Said Abd Alhalim]

enabled TCP/IP :the same Error in SQL Server 2000 not 2005