Re: 'Microsoft Search service cannot be administered under the present user error' SP3

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Kane (jt-kane_at_comcast.net)
Date: 05/08/04 

Date: Fri, 7 May 2004 20:05:39 -0700

Oz,
In addition to the many things you tried below... a couple of things
specific to MSSearch and the MSSQLServer services...
1. Is the MSSearch service started and running under the System
(LocalSystem) account? If not, then change it to LocalSystem and stop and
re-start this service.

2. Have you or anyone else change the MSSQLServer account &/or password via
Win2K's Component service? IF so, then you MUST re-change the change via the
Enterprise Manager's server property security tab as this is the only place
where the two services security are kept in sync. See KB article 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

3. Have you or anyone else removed or modified the BUILTIN\Administrator
login on this server? If so, you MUST either re-add it with all of it's
normal default rights, especially sysadmin rights and with the default
database as master and the default language of English or use the following
T-SQL code to add the correct permissions:

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

Additionally, but not necessarily related to the error in the subject line,
has this server ever been upgrade from SQL Server 7.0 or is this SQL Server
2000 a "named instance" with a default installation of SQL Server 7.0? As
this might be related to a post-SP3 bug. See KB 814035 (Q814035) FIX: A
Full-Text Population Fails After You Apply SQL Server 2000 Service Pack 3
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;814035 (80004002 -
No such interface supported)

Regards,
John

"Oz" <Oz(no_spam)@nospam.com> wrote in message
news:eytulHGNEHA.2468@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> We have SQL Server private installation on which we are developing an
> application and public installation on whict we will be deploying the
> application. All instances have run Windows 2003 Enterprise Edition with
SQL
> 2000 SP3. However, the public installation MS Search is not functioning
> correctly. Basically it will not full-text indeed databases and produces
> the following error
>
> 1> exec sp_fulltext_database 'enable'
> 2> go
> (1 row affected)
> Msg 7635, Level 16, State 1, Server SIMP001, Procedure
sp_fulltext_database,
> Lin
> e 46
> The Microsoft Search service cannot be administered under the present user
> account
>
> Now, we have tried many things to try and solve this error, mainly based
on
> search newsgroups, which are itemized below:
>
> 1 Reboot System and reexecute sp_
> 2 Complete reinstall of SQL on system, then reapplication of SP3
> 3 Same as above (2) but reapply SP3a
> 4 Remove SQL Server installation subkey in order that can reinstall
> full-text search only, then reapply SP3
> 5 Check from keys under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\ to make
sure
> SQL Server was there. It wasn't, removed SQL subkey and reinstalled,
> re-adding full-text search as an option (to re-install full-text) then
> reapplied SP3
> 6 Try reinstall, but do not reapply SP3 until have full-text enabled the
> database.
>
> None of the above worked. We still have a none functioning mssearch and
> full-text disabled database on the system.
>
> We have even tried enabling on a blank database. This does not work
either.
>
> PLEASE HELP! Getting desperate as the whole application depends on having
> search ability.
>
> Thanks
>
> Oz
>
>

Relevant Pages

  • Re: Microsoft Search service cannot be administered under the present user error SP3
    ... Is the MSSearch service started and running under the System ... Have you or anyone else change the MSSQLServer account &/or password via ... database as master and the default language of English or use the following ... has this server ever been upgrade from SQL Server 7.0 or is this SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Microsoft Search service cannot be administered under the present user error SP3
    ... Is the MSSearch service started and running under the System ... Have you or anyone else change the MSSQLServer account &/or password via ... database as master and the default language of English or use the following ... has this server ever been upgrade from SQL Server 7.0 or is this SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: What DB to use?
    ... Access provides a single benefit: ... everyone must exit the database so that it can be repaired. ... to a full copy of SQL Server. ... > Development on MSDE on the desktop and migrate to MSSqlServer? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Any one tell export Sql Database in access hole object
    ... You can certainly use SQL Server DTS to move data to ... Is .NET important for a database professional? ... "khurram alam" wrote in message ... I want to export my mssqlserver 2000 database with all relation ship and all ...
    (microsoft.public.sqlserver.tools)
  • RE: Cannot Enable full-text search and index component
    ... Make sure the Indexing Service not just mssearch on the server is started. ... On your computer running SQL Server, open a command prompt and run the ... Open SQL Server Query Analyzer and connect to the database for Windows ...
    (microsoft.public.sharepoint.windowsservices)