Distributed queries from SQL Server 7.0 to 2000

[James Bothamley]

We're trying to setup a linked server connection from a SQL Server 7.0 server to a SQL Server 2000 server instance. Has anyone tried this successfully? If so, we would be interested in learning about the steps you performed to accomplish this. Thanks. James E Bothamley.

[James Bothamley]

I was able to answer my own question. Here are the steps:

Using SQL Server Client Network Utility setup a server alias. We used the following information:

Server Alias - <Alias Name>
Network Library - TCP/IP
Connection Parameters - <SQL 2K Server Name>,<SQL 2K Instance port number>

Using Enterprise manager, we used the following information:

Linked Server Name - <Alias Name>
Server Type - SQL Server
Security - Whatever you want. We used &#39;They will be mapped to&#39;

Now you query follows traditional distributed syntax:

select * from [<Alias Name>].[<Database Name>].[<Table Owner>].[<Table Name]

------------
James Bothamley at 6/28/01 12:00:18 PM

We&#39;re trying to setup a linked server connection from a SQL Server 7.0 server to a SQL Server 2000 server instance. Has anyone tried this successfully? If so, we would be interested in learning about the steps you performed to accomplish this. Thanks. James E Bothamley.