All -- I have a development VM server with Windows Server 2008-R2 and on it I have the following versions of SQL Server Installed:
- SQL 2000 - Developer Edition
- SQL 2005 - Enterprise Edition
- SQL 2008-R1 - Enterprise Edition
- SQL 2008-R2 - Enterprise Edition
- SQL 2012 - Enterprise Edition
Each of these SQL Instances are named instances where I use the Version number in the name such as:
I am able to access all of these instances from the local machine without any issues and with the exception of the SQL 2000 instance I can access (login) all of them from a remote machine using SSMS 2012. I am not able to access the 2000 instance using SSMS 2012 remotely but strangely I am able to access the SQL 2000 instance with SSMS 2012 Locally. I am also able to access the SQL 2000 instance remotely using SSMS 2008-R2.
So I don't think that it is a firewall issue nor would it be an issue regarding remote access but I am out of ideas, am I missing something?
Ok, I finally had some time to get back to this I am still not able to access the SQL2K0 instance via SSMS 2012 but I installed SSMS 2008-R2 and I am able to connect to the SQL 2K0 instance. So now I am ready perplexed!!!!!