Is this still a valid point: Microsoft has made it quite clear that the only way the Full Text Search service is supported is if it is running under LocalSystem. This came from an article cncerning security and logins in the SSC forums.
I am locking down a SQL 2005 (Entterprise Edition) system on WIndows 2008 Enterprise server (latest service pack) per goverment DOD standards. A particular STIG requires all SQL sewrvices ruun under a dedicated account (none can run under Local System). I have created 4 accounts for the sql services (still need to assign user rights) but wanted to know if the above statement is true. If so, then I can leave under local system and document the above as a refernece.
Thanks for any help or info on this.
To the contrary, Microsoft strongly recommends AGAINST using LocalSystem http://msdn.microsoft.com/en-us/library/ms345189(SQL.90).aspx
I am sucessfully using low privilege domain accounts for this.