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

From: Oz (Oz(no_spam)_at_nospam.com)
Date: 05/08/04 

Date: Sat, 8 May 2004 14:02:42 +0300

Hi John,

Thanks for replying to my message. Unfortunately i forgot to add these items
as items i had also tried.

- Have not modified Administrator account, but i ran the SQL script anyway.
- MS Search has always been running as local system
- Changed the security settings using Ent Mgr to Local System and back again
to the user account.
- SQL account is not a local administrator. Tried adding it Administrators,
still, no joy.

Thanks

O

"John Kane" <jt-kane@comcast.net> wrote in message
news:eaSiYlKNEHA.2976@TK2MSFTNGP10.phx.gbl...
> 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: BULK Insert Problem
    ... > I Log on to my system using the Local System Administrator Account. ... > do I see that The SQL Server Service is starting using the Local Account ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: user and group permissions
    ... Within SQL - Security - Logons - remove Administrators. ... add SQLAdmins as the SQL Server Role of System ... > Is it possible to deny access to local NT administrator ... > cluster runs under domain user account with adminstrator ...
    (microsoft.public.sqlserver.clustering)
  • RE: Win2000 OS Access for SQL Server Admin
    ... yet the other SQL services start successfully before ... Admin account. ... LocalSystem has more privledges than local administrator. ... SQL Server Agent connects to SQL Server using SQL Server Authentication ...
    (microsoft.public.sqlserver.security)