Re: The Microsoft Search service cannot be administered under the present user accou
From: John Kane (jt-kane_at_comcast.net)
Date: 09/29/04
- Next message: Mac Littlefield: "Re: "Full-Text Indexing" is Grayed Out, Disabled"
- Previous message: Vinodh: "The Microsoft Search service cannot be administered under the present user accou"
- In reply to: Vinodh: "The Microsoft Search service cannot be administered under the present user accou"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Sep 2004 01:18:51 -0700
Vinodh,
When you changed the SQL-Service to run with Local User account (with admin
rights), did you make this change in the SQL Server 2000 Enterprise Manager
(EM)? Specifically, under the server's property security tab? If not, then
you must re-do the change via the EM and be sure that the Local User account
is a member of the server's Admin Group. If possibly, use either the system
account (LocalSystem) or a DOMAIN\Account where the login DOMAIN\Account is
a member of the server's Admin. Group. Two good KB articles to review for
these types of issues are:
277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services] at http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
317746 (Q317746) "PRB: SQL Server Full-Text Search Does Not Populate
Catalogs" at http://support.microsoft.com/default.aspx?scid=kb;en-us;317746
Additionally, a common cause of the error "The Microsoft Search service
cannot be administered under the present user account" is a missing
(removed) or modified SQL Server 2000 BUILTIN\Administrators login. Is this
Login present on your server? If so, it must be configured with the default
of master database, English and most importantly have the server role of
System Admin (sysadmin) check marked. If for security reasons, you or your
network administrator has removed this login, then you can use the following
SQL code to add back the functionality that the MSSearch service requires in
order to function correctly:
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
When you say that you have "tried it re-installing a few times" are you
referring to re-installing SQL Server or just the Full-text Search and
MSSearch components?
Hope this helps!
Regards,
John
"Vinodh" <vinodh_0124@yahoo.co.in> wrote in message
news:352901c4a5f4$5649b1d0$a501280a@phx.gbl...
>
> We have a problem with implementing Full-Text capability.
>
> Here are the details about our system: We have:
> 1) Windows 2000 Server
> 2) Windows SQL-Server 2000 Server with SP3a
> 3) And Full-Text component installed while installing SQL-
> Server 2000.
>
> -- We installed SQL-Server 2000 with a user with admin
> rights.
> -- The Microsoft Search is running with Local User account
> (with admin rights)
> -- We have changed the SQL-Service to run with Local User
> account (with admin rights).
>
> But even then, when we try to create a Full-Text Catalog,
> we get the error "The Microsoft Search service cannot be
> administered under the present user account". From both EM
> and Query Analyser. We tried it re-installing a few times
> and we get the same error.
>
- Next message: Mac Littlefield: "Re: "Full-Text Indexing" is Grayed Out, Disabled"
- Previous message: Vinodh: "The Microsoft Search service cannot be administered under the present user accou"
- In reply to: Vinodh: "The Microsoft Search service cannot be administered under the present user accou"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
