Linked server issues for named instances.

Howdy all. Ive configured linked servers plenty of times, but now Im
wondering if Ive ever done it on a named instance. I've got an SQL 2000 SP2
box that I can link up to default instances with no issue. But when I try to
link it to a named instance (various editions and service packs) it blows up
with:
"SQL Server does not exist or access is denied. "
I know it's not a login/ permissions issue as I've went so far as to use SA
on both the "source" and "destination" boxes. BOL says I can happen, so Im
not understanding what the problem is?
TIA, ChrisRHello,
Can you aricreate a server alias for the named instance using Client network
utility and then use this alias to create a linked server.
Thanks
Hari
"ChrisR" <ChrisR@.NoEmail.com> wrote in message
news:%237IBRMvIHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Howdy all. Ive configured linked servers plenty of times, but now Im
> wondering if Ive ever done it on a named instance. I've got an SQL 2000
> SP2 box that I can link up to default instances with no issue. But when I
> try to link it to a named instance (various editions and service packs) it
> blows up with:
> "SQL Server does not exist or access is denied. "
> I know it's not a login/ permissions issue as I've went so far as to use
> SA on both the "source" and "destination" boxes. BOL says I can happen,
> so Im not understanding what the problem is?
> TIA, ChrisR
>|||A couple items to check:
1. Check the MDAC version. Updating to the latest might help resolve the
issue.
2. Check your firewall. The named instances are assigned dynamic port for
communication and you firewall might be dropping the packets. Normally a
good idea to assign a static port for the named instance and to configure
your firewall.
3. It is worth updating SQL Server to the latest SP.
Here are some useful links to troubleshoot the issue:
http://support.microsoft.com/kb/328306/
http://support.microsoft.com/kb/287932
http://support.microsoft.com/kb/827422/
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"ChrisR" <ChrisR@.NoEmail.com> wrote in message
news:%237IBRMvIHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Howdy all. Ive configured linked servers plenty of times, but now Im
> wondering if Ive ever done it on a named instance. I've got an SQL 2000
> SP2 box that I can link up to default instances with no issue. But when I
> try to link it to a named instance (various editions and service packs) it
> blows up with:
> "SQL Server does not exist or access is denied. "
> I know it's not a login/ permissions issue as I've went so far as to use
> SA on both the "source" and "destination" boxes. BOL says I can happen,
> so Im not understanding what the problem is?
> TIA, ChrisR
>