Connecting to a Named Instance of MS SQL Server 2000 using Query Analyzer
Posted on 2004-11-30
Issue: Connect to MS-SQL-Server 2000
OS: Windows Server 2003 Standard Edition
I have 2 differend network servers each running Windows Server 2003 SE as the Network Operating System (NOS) (Primary and Secondary). Let's name them WS2K3_SVR1 and WS2K3_SVR2. Each network server has a named instance of MS SQL Server 2000 running on them. Let's call them WS2K3_SVR1\Inst and WS2K3_SVR2\Inst. Using Query Analyzer, I can connect from my workstation running Windows 2000 Pro over the network to WS2K3_SVR2\Inst using Windows Authentication, but I can not connect to WS2K3_SVR1\Inst using Windows Authentication. My network user ID is a member of the Administrators Group in Computer Management on both Network Servers. Both network servers are located in a different state from where me and my workstation are located. Connectivity is over an Intranet using TCP/IP.
Looking in Enterprise Manager (EM) using (Remote Admin) on both systems, under the instance name of each MS SQL Server 2000 instance: \\Console Root\Microsoft SQL Servers\SQL Server Group\WS2K3_SVR1\Inst\Security\Logins "BUILTIN\Administrators Windows Group" is listed.
The only difference I see at this point is the string "SQL Server Group" in the path. It is different on the one that I can connect to. That is because on installation it was assigned that way. "SQL Server Group" looks to me like a generic name provided as a default by the setup installation program. The default was not taken when WS2K3_SVR2\Inst was installed. That is the one that I can connect to. This part of the instance name is not specified anywhere that I can find in any of the syntax definitions that I can find for how to specify a connect string.
So why can I not connect..??