Hi everyone

Apologies if this is in the wrong group.

Is it possible to create a linked server connecting to Index Service running
on a remote machine? If so, can you let me know how the properties of the
provider should be set?

Many thanks, and regards

Simon

Simon,

Here is what I did a couple or three years ago.

EXEC master.dbo.sp_addlinkedserver @server = N'FullTextRemoteIndex',
@srvproduct=N'RemoteIndex', @provider=N'SQLNCLI',
@datasrc=N'OtherServerName'
EXEC master.dbo.sp_addlinkedsrvlogin rmtsrvname=N'FullTextRemoteIndex',
@useself=N'True', @locallogin=NULL, @rmtuser=NULL, @rmtpassword=NULL
EXEC master.dbo.sp_serveroption @server=N'FullTextRemoteIndex',
@optname=N'data access', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'FullTextRemoteIndex',
@optname=N'rpc', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'FullTextRemoteIndex',
@optname=N'rpc out', @optvalue=N'true'

RLF

"SimonG" <SimonG (AT) discussions (DOT) microsoft.com> wrote