Sunday, February 26, 2012

Full-Text Search stopped for confict in service accounts

Hi:
In me organizattion are one sql 2000 server with the dbs.
When remote users connect to this server can't see the Full-Text Search
running.
The Microsoft Search service in windows are running.
I was read that the problem concern to change the user of microsoft sql
services after install the server. This is the poit. This server have this
problem. I change the user of sql services after install the sql.
Have any form of resolve this confinct without reinstall the sql server?
Thanks a lot
cyberMSSearch must run under the local system account. One of the reasons SQL FTS
might not work is because you change the account that MSSQLServer runs under
using control panel. If so you should locate your server in Enterprise
Manager, right click on it, and select properties, then click the security
tab, and change it back to system, SQL Server will prompt you to stop and
start it. Then change it back to the local admin account.
I suspect you are actually running into this problem -
http://www.indexserverfaq.com/tablenotenabled.htm
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
"cyb165er" <cyb165er@.discussions.microsoft.com> wrote in message
news:CBD24B8D-9D09-4EC0-84C0-84D48F7344CC@.microsoft.com...
> Hi:
> In me organizattion are one sql 2000 server with the dbs.
> When remote users connect to this server can't see the Full-Text Search
> running.
> The Microsoft Search service in windows are running.
> I was read that the problem concern to change the user of microsoft sql
> services after install the server. This is the poit. This server have this
> problem. I change the user of sql services after install the sql.
> Have any form of resolve this confinct without reinstall the sql server?
> Thanks a lot
> cyber

No comments:

Post a Comment