Linked Server and Server Registration

I am trying to set up a linked server from a SQL 7 sp3 box
to a SQL 2000 sp3 named instance server. I keep getting
the following error.
Server: Msg 11, Level 16, State 1, Line 1
General network error. Check your network documentation.
I can however connect from a SQL Server 7 sp4 box with no
problem. We have checked connectivity and other options
with no luck. Is there a problem with SQL 7 sp3 connecting
to a SQL 2000 named instance box? Any suggestions?It may have to do with your MDAC version. Can you make an OSQL connection
from the SQL7 box to the SQL2K box?
If you have an older version of MDAC you may need to create an alias with
cliconfg and use the alias when you create the linked server. That's
because older versions of MDAC don't know about named instances.
For instance, if your named instance is SQL1\Inst1, on the SQL7 box run
cliconfg.exe and create an alias named SQL1_Alias.
Point SQL1_Alias to SQL1\Inst1. Then in your linked server query specify
SQL1_Alias.
270126 PRB: How to Manage Client Connectivity to Both SQL Server 2000
Virtual
http://support.microsoft.com/?id=270126
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.