Re: The Microsoft Search service cannot be administered under the pres
From: John Kane (jt-kane_at_comcast.net)
Date: 12/17/04
- Previous message: John Kane: "Re: Catalog Population Fails on Cluster"
- In reply to: Thomas Weidman: "The Microsoft Search service cannot be administered under the pres"
- Next in thread: Thomas Weidman: "Re: The Microsoft Search service cannot be administered under the"
- Reply: Thomas Weidman: "Re: The Microsoft Search service cannot be administered under the"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 16 Dec 2004 20:09:28 -0800
Thomas,
You may have full access to the system, but the "Microsoft Search"
(mssearch.exe) service may not as it uses the BUILTIN\Administrators account
to access SQL Server. Specifically, Is the master the default database for
the BUILTIN\Administrator account as well as a member of the Sysadmin role?
When you changed it to run under the System Account (LocalSystem) did you do
this via the Enterprise Manager's server security tab?
You should review the following KB articles:
317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/default.aspx?scid=kb;en-us;317746
277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
If for security reasons, you or your server's sysadmin have removed the
BUILTIN\Administrators account, you can use the following T-SQL code to
restore similar permissions for the MSSearch service to use as it runs under
the Localsystem account:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
Regards,
John
"Thomas Weidman" <Thomas Weidman@discussions.microsoft.com> wrote in message
news:23916357-C3C3-4C63-AFED-88FE0273B68D@microsoft.com...
> I am trying to enable Full Text Searching on a SQL Server 2000 DB. I have
> full access to the system, but cannot get it to work. It is running as an
> Instance and the Search Service is running. I have tried running the Full
> Text Windows by logging into the Server using the Local Administrator
> Account. The DB is running SQL Server 2000 Std, with SP3a. The Server is
> Windows 2000.
>
> Any ideas on what to try or how to resolve this problem. It is a
production
> server, so if I must take it offline, that must be a last resort.
>
> Thanks,
>
> -Thomas
- Previous message: John Kane: "Re: Catalog Population Fails on Cluster"
- In reply to: Thomas Weidman: "The Microsoft Search service cannot be administered under the pres"
- Next in thread: Thomas Weidman: "Re: The Microsoft Search service cannot be administered under the"
- Reply: Thomas Weidman: "Re: The Microsoft Search service cannot be administered under the"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
