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.