Friday, February 10, 2012

Connecting to SQL Server 2k5 Dev Edition

I recently removed my June CTP version of SS2k5 and installed the release developer version on a 2 proc server with Win Server 2003 SP1 (I'll call this machine Server), and suddenly I cannot connect to this box over our network. I have SS2k5 Dev Edition installed on my local machine (WinXP, and I'll call this machine Local), and was able to connect to the CTP version on the server with no problems. Now, not only can I not connect (or see the server through the network browse) to the Server from Local, nor can I connect or see my Local from the Server. I used the Surface Area Configuration tool to allow TCP/IP and Named Pipe connections (Local was set to local only connections, but was working fine to and from the CTP version of the Server), but to no avail.

Are there any other settings that I should look at? I'm working a bit in the dark here.

Thank you,

NoelHi Noel,

So I understand the problem you're experiencing, let me restate the problem. :)

On SERVER, which is Windows Server 2003 SP1, you have SQL 2005 Dev RTM.
On LOCAL, which is Windows XP SP2, you also have SQL 2005 Dev RTM.

When you say you "cannot see" SERVER from LOCAL or LOCAL from SERVER, what do you mean? Can you PING LOCAL from SERVER and vice versa by name? by IP?

Did you run the Surface Area Configurator on both machines and ensure Local + Remote access was enabled? After enabling TCP\IP and Named Pipes on LOCAL, did you stop and restart the service (this has to be done for the service to start listening on those protocols)?

jeff.|||Also, if your instance name is a named instance you'll need to start the SQL Browser service. If the Windows Firewall is enabled you'll need to add exceptions for sqlservr.exe and sqlbrowser.exe. To find the path to the correct SQL Server executable check out the "Path to executable" in the Windows Service Control Manager for the SQL Server service.

This blog for SQL Server Express is also relevant for Dev edition: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Dan

No comments:

Post a Comment