Groups | Blog | Home
all groups > sql server (microsoft) > june 2007 >

sql server (microsoft) : SQL and Indexing Service on different servers


Alexey Smirnov
6/30/2007 7:12:37 AM
I have a web app with a search based on Indexing Service and SQL 2000
(on the same box). Now, I need to move it to a new web server and a
separate dedicated SQL 2005. So, what should I do to be able to use
the same search using remote server?
Hilary Cotter
7/1/2007 12:49:28 PM
Either use a linked server to the local indexing services catalog and then
use the four part query syntax to query the remote indexing services, or
index the remote server as network shares using the local indexing services
and query it that way.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Alexey Smirnov
7/2/2007 12:11:39 AM
[quoted text, click to view]

Hi, Hilary

thanks for your reply,

[quoted text, click to view]

How does it work, should I start the indexing service on both
servers?

Thanks
AddThis Social Bookmark Button