SQL Server 2008. Allow Remote Connections?

Question

I have SQL Server 2000 and 2008 installed on a Windows XP Pro box. I can connect to both db instances locally.

From another box, a Windows 7 box, I can connect to the SQL 2000 instance on the first box but I cannot connect to the 2008 instance using the same SQL Server authentication credentials that worked locally.

Allow Remote Connections is set to TRUE for both the 2000 and 2008 database instances.

What else can I look for to be able to connect to the remote 2008 instance from the Windows 7 box?

I am trying to connect using Mgt Studio 2008.

Answer 1

Just a guess, is the 2008 SQL instance configured to be "listening" for TCP connections? (It wasn't on a box I recently checked.) To Determine, drill down to:

• Start, Microsoft SQL Server 2008, Configuration Tools, SQL Server Configuration Manager
• SQL Server Network Configuration
• Protocols for [instance name]
• There should be four items listed: Shared Memory, Named Pipes, TCP/IP, VIA

For your environment, which should be enabled and which should be disabled? Most setups call for Shared Memory and TCP/IP enabled, the others disabled.

Answer 2

Is there a firewall possibly stopping the port that 2008 is listening on?

Answer 3

Try connecting by specifying a port,

eg: servername,1433

or

servername\instance,1433