Cannot connect to a 2000 named instance

[MK]

I have one user that is unable to connect via 2000 Query Analyzer to a
named instance of SQL 2000. I confirmed that the MDAC and SQL Server
driver versions are the most recent and same as mine. She can't
connect via IP, nor by IP,port#. Her Client network settings include
TCP/IP on 1433 and Named Pipes. I tried adding an alias, nothing. I
tried removing TCP/IP, nothing. Her local firewall is turned off.
She can connect fine to a default instance and use the linked server
to query the named instance as a workaround.

The only thing that has changed on her machine is that Office 2007 was
installed.

WHY can she NOT connect directly to the NAME INSTANCE??

Any other ideas are greatly appreciated.

[Tom Moreau]

Can she telnet to the IP and port?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"MK" <mhed...@libertysite.com> wrote in message
news:19ca7d7d-3b63-44e5...@34g2000hsz.googlegroups.com...

[MK]

Yes, she can telnet via telnet dbmcrpcl1sqld 1825.

On Feb 29, 12:23 pm, "Tom Moreau" <t...@dont.spam.me.cips.ca> wrote:
> Can she telnet to the IP and port?
>
> --
>    Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
>

> "MK" <mhedb...@libertysite.com> wrote in message

[MK]

I finally got the connection to work by using an alias an specifying
the port number. So she is able to work now but do you know what
might cause this alias as a requirement?

> > Any other ideas are greatly appreciated.- Hide quoted text -
>
> - Show quoted text -

[Tibor Karaszi]

If you can connect by the port number but not the instance name, then check if port 1434 UDP is
passed through your firewalls. This is what the component that translates instance names to port
numbers are listening to. And if you on the server have 2005 stuff, you also need the SQL Server
browser service started.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"MK" <mhed...@libertysite.com> wrote in message

news:37aa1951-131e-4bc6...@s37g2000prg.googlegroups.com...