Connecting Server Management Studio to a database on remote server

To use the front end tools in SQL Manager on the database at my ISP I want to connect directly from Server Management Studio ( Or Server explorer i VS). I have enabled TCP/IP without succes.

My installation is based on SQL Server Developer Edition and VS 2005. With my previos installation based on Express versions of the product this worked fine.

In VS 2005 I select Tools -> Connect to database and fill inn the dialog window with the serveraddress (sql01.active24.com), username and password. I then get the following message:

An errror has occurd while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the fefault settings SQL Server does not allow remote connections. (provider: Named pipes, errror: 40 - Could not opeen a connection to SQL Server

In the network configuration I have now disabled Named Pipes and enabled TCP/IP.

Thanks in advance!

---

Andreas

Report Abuse

Open the Surface Area Configuration (SAC) tool, and enable remote connections. By default the developer edition has all that turned off.

Buck Woody