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
- Next message: Oz: "Re: 'Microsoft Search service cannot be administered under the present user error' SP3"
- Previous message: Tibor Karaszi: "Re: Buy SQL Server 2000 or..."
- In reply to: John Kane: "Re: 'Microsoft Search service cannot be administered under the present user error' SP3"
- Next in thread: Oz: "Re: 'Microsoft Search service cannot be administered under the present user error' SP3"
- Messages sorted by: [ date ] [ thread ]
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
> >
> >
>
>
- Next message: Oz: "Re: 'Microsoft Search service cannot be administered under the present user error' SP3"
- Previous message: Tibor Karaszi: "Re: Buy SQL Server 2000 or..."
- In reply to: John Kane: "Re: 'Microsoft Search service cannot be administered under the present user error' SP3"
- Next in thread: Oz: "Re: 'Microsoft Search service cannot be administered under the present user error' SP3"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
