Microsoft Search Service

Question

Microsoft Search Service

Maverick100877

SSCertifiable

Points: 5240
More actions
October 24, 2007 at 8:30 pm

#70373

Hi All,
The full text index uses the Microsoft Search service. It is recommended that it should run under the Local System Account.
I have two questions here
1>>Does it only works under the local system account??
2>>If it runs under the local system account and let say we create full text catalogs on network drives(SAN) then how does it access them.:crazy:

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 1

Maverick (10/24/2007)
Hi All,
The full text index uses the Microsoft Search service. It is recommended that it should run under the Local System Account.
I have two questions here
1>>Does it only works under the local system account??
2>>If it runs under the local system account and let say we create full text catalogs on network drives(SAN) then how does it access them.:crazy:

Taken from BOL:

For the Full-Text Search service account, we strongly recommend using a low-privileged domain user account with only User rights and permissions on the local computer. Also, to ensure you are running the service with the lowest possible privileges, each instance of Full-Text Search should have a dedicated service account.

For security considerations, do not use LOCAL SYSTEM, LOCAL SERVICE, or NETWORK SERVICE as the service account to run MSFTESQL. This could provide an elevation of privileges for the Full-Text Search service.

--Ramesh

VaiydeyanathanVS Hall of Fame Points: 3053 More actions · Answer 2

please find the links... Try to implement by going through the documents specifications...

http://www.microsoft.com/exchange/downloads/2000/sp3/Rnotes_US.htm

technet.microsoft.com/library/ms345119.aspx

Maverick100877 SSCertifiable Points: 5240 More actions · Answer 3

I'm not sure but I read this somewhere here only on this site

"The Full Text Search service is also known as Microsoft Search if you're looking for it under your list of services. Microsoft has made it quite clear that the only way the Full Text Search service is supported is if it is running under LocalSystem. Whether or not you're running it on a clustered instance of SQL Server makes no difference"

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 4

Maverick (10/25/2007)
I'm not sure but I read this somewhere here only on this site
"The Full Text Search service is also known as Microsoft Search if you're looking for it under your list of services. Microsoft has made it quite clear that the only way the Full Text Search service is supported is if it is running under LocalSystem. Whether or not you're running it on a clustered instance of SQL Server makes no difference"

I guess this is applicable to versions below 2005 where only a single service called Microsoft Search is solely responsible for handling every instance on the server. There were some known issues in this service when ran under an account other than localsystem.

Whereas in 2K5 a tightly integrated Microsoft Full-Text Engine for SQL Server MSFTESQL) service is available.

--Ramesh

Maverick100877 SSCertifiable Points: 5240 More actions · Answer 5

Yes I"m talking in terms of SQL server 2000 only.

Recently we faced errors with Full text indexes when one of our Cluster server failed over to the other node. On this node the Microsoft Search was running under a domain account rather than the Local System Account.

When we failed it back to the other node on which Microsfot Service was running under Local System account then the problem was resolved.

So jsut wanted to clarify that if it runs under the Local System Account then how it access the full text catalog which is created on a vetwork drive (SAN).