Connecting to a Named Instance of MS SQL Server 2000 using Query Analyzer

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..??

Ted Palmer
Ted PalmerInformation Technology ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

muzzy2003Commented:
What TCP/IP ports are the instances responding on? Can you Telnet to them on the relevant port?
0
Ted PalmerInformation Technology ConsultantAuthor Commented:
If you send e-mail to the address in my profile, I won't see it till I get home. My e-mail address at work is different from the one in my profile and I don't want to include it here.
0
muzzy2003Commented:
That aimed at me, or a general comment?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Ted PalmerInformation Technology ConsultantAuthor Commented:
Using the SQL Server Network Utility I can tell that they are both the default 1119.
0
Ted PalmerInformation Technology ConsultantAuthor Commented:
General comment.
0
muzzy2003Commented:
OK. Do you know their IP addresses? You can probably resolve it by pinging them, even if the ping doesn't get through. Once you have them, type:

telnet xx.xx.xx.xx 1119

at the command prompt to see if you can connect to each of them in turn. If one responds and the other doesn't, then you have one of the following problems with the SQL Server that is the difficulty:

1. There is a firewall between you and the server that isn't open on port 1119.
2. The SQL Server box is turned off, or service is not started.
3. There is no network route resolveable between you and the server.

I would strongly suspect 1 given what you have said about the locations.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ted PalmerInformation Technology ConsultantAuthor Commented:
If I try to telnet using port 1119 I get "unable to connect to host".
0
muzzy2003Commented:
On the dodgy machine or on both?
0
Ted PalmerInformation Technology ConsultantAuthor Commented:
When I telnet to the one that I can connect to on port 1119, I get a Ready prompt. I never would have thought of trying to telnet to a MS SQL Server running on port 1119. I thought Telnet was port 23..??

I have to go to a meeting with my boss. I'll be back soon I hope..!!
0
muzzy2003Commented:
Telnet can be used on any port, it simply establishes that there is a listener there. You almost certainly have a firewall issue I would say. The firewall guys have probably opened up the default instance port of 1433 and not expected the named instance port you need of 1119.
0
Ted PalmerInformation Technology ConsultantAuthor Commented:
muzzy2003:

It appears that item 1 of the 3 item list is the cause of the problem. I can ping both hosts. I can establish a telnet connection to the same MS SQL Server that I can connect to using Query Analyzer; but I can not do the same for the MS SQL Server that I also can not connect to using Query Analyzer.

The resolution of these issues is outside the scope of this question. At least I now know what the issue is that has to be resolved. Making that happen is another bureaucratic night mare that will consume more of my time than I even want to think about. But that is my problem. You got the solution so you get the points.

THANK YOU..!!
0
muzzy2003Commented:
It's a pleasure. As you can probably tell, I've run into the same problem more times than I care to remember. One of the downsides of being a contractor - every time you move companies, you have start educating the firewall gorillas all over again ...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.