Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Database connectivity issue

Author  Topic  Madhav Starting Member 38 Posts Posted - 2010-05-18 : 08:57:43 Hi all, I am facing an issue while connecting to sqlserver 2000 named instance. We have a new Dev Box with Windows server 2008 (SE, 32Bit). I was first installed sqlserver 2008 named instance (machinename\SQL2008)and applied sp1. Later installed sqlserver 2000 named instance (machinename\SQL2000) and applied SP4. I can able to connect both instances from the server. But when I try to connect to machinename\SQL2000 from remote client, I am getting the below error. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) I can able to connect to sqlserver 2008 named instance form remote client successfully. Why I am getting this error while connect sql2000 named instance. I have disabled windows firewall but of no use. While troubleshooting this issue, I found that the named instance machinename\SQL2000 is not there in Instance Names drop down list on "Server Network Utility". Can you please help me troubleshooting this issue?? Thanks in Advance.