Discussion:
SQL and Indexing Service on different servers
(too old to reply)
Alexey Smirnov
2007-06-30 14:12:37 UTC
Permalink
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
2007-07-01 16:49:28 UTC
Permalink
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
Post by Alexey Smirnov
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?
Alexey Smirnov
2007-07-02 07:11:39 UTC
Permalink
Post by Hilary Cotter
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.
Hi, Hilary

thanks for your reply,
Post by Hilary Cotter
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
How does it work, should I start the indexing service on both
servers?

Thanks

Loading...