REPOST: Configuring Linked Server to Remote Index Server 
Author Message
 REPOST: Configuring Linked Server to Remote Index Server

Hello,

I have 2 servers.  Server1 hosts SQL Server 2000 and Server2 hosts IIS and
Index Server.  I would like to configure a linked server on Server1 that
points to the Index Server on Server2.  Can this be done?

I understand that if the Index Service is running on Server1 I could simply
do:

exec sp_addlinkedserver WhateverName,
'Index Server',
'MSIDXS',
'Web'

However, how could I configure this linked server to point to the Index
Service on Server2?  Could I simple replace 'MSIDXS' with
'\\Server2\MSIDXS'?

Any advice would be greatly appreciated.

Thanks a lot.

P.S.  I have tried using server2.web..scope() but continually receive an
access denied error.



Fri, 06 Jan 2006 17:14:27 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Configuring Linked Server to Remote Index Server

2. Remote Server -- Changing from Remote Server to Linked Server

3. Configuring server as Distributor for remote server

4. linking to remote index server

5. Remote SQL Linked Index Server Query

6. Configure linked server to MSSQL7 server by IP?

7. Linked Server How to configure another SQL Server

8. Repost: Cannot configure the server error

9. Remote Servers vs Linked Servers

10. remote server vs linked server.

11. Linked Servers/Selecting from remote server

12. Remote server vs Linked server


 
Powered by phpBB® Forum Software