Re: Problem with Search engine access?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

John,
The error "The Microsoft Search Engine cannot be administered under the
present user account" typically indicates that the SQL login
BUILTIN\Administrator has been removed or altered. Have you or anyone else
removed or altered the SQL Server login BUILTIN\Administrator? If so, can
you add or alter it back with the same parameters? As the MSSearch service
needs all of the default parameters to login to SQL Server, if not you can
use the following SQL code:

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

See "SQL Server 2000 Full-Text Search Resources and Links" for more SQL FTS
info & KB articles at:
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!305.entry

Regards,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/


"John S" <js162@xxxxxxxxxxxxxxxx> wrote in message
news:0C9748C6-AB94-4AC3-AEED-4F97C1FCC49B@xxxxxxxxxxxxxxxx
> Hi,
>
> We're running a Windows 2000/2003 network.
>
> On Servers running Windows 2003 with or without SP1 and SQL Server 2000
SP3a
> or 4, we cannot create any full Text Search Catalogs.
>
> Whatever login we try to use, if we try to create a new catalog, from
> Enterprise Manager, we get a dialog box stating "The Microsoft Search
Engine
> cannot be administered under the present user account"
>
> Running profiler we can see the creation process starting. It appears to
run
> alright until it gets to the "sp_fulltext_database DBCC CALLFULLTEXT
> (7,@dbid) -- FTDropAllCatalogs("@dbid") and then generates an Exception
> "Error: 7635, Severity: 16, State: 1"
>
> Help!


.

Relevant Pages

  • Re: Permission question - another one
    ... If I add an Sql Login it does add the TRAVAC\ in front of the names, ... seems to be users that were setup to use SQL Server Authentication. ... RAPTOR is the Server that has SQL Server running on it. ... > " I could think I am taking permissions away from someone, ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2k5 SP2 Mirroring - SQL in Mixed mode.
    ... US\sqlservices (old SQLservice account) still member of built-in local admin ... Login: US\sqlservices ... How can I transfer the SQL logins to ... Here is SP_help_revlogin results from the Principal Server (NYSQL-3) ...
    (microsoft.public.sqlserver.clustering)
  • Re: Renamed Windows login not found in SQL Server 2000
    ... It's almost like SQL tuck some knowledge away in an area ... of memory that only gets released on Windows stop. ... > I am running SQL Server 2000 SP2 with Windows ... > login gets corrupted) I am unable to add the new login to ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)
  • Re: Changing DB Owner
    ... specified login must not already be a user in the database. ... USE MyDatabase ... EXEC sp_changedbowner 'SQLAdmin' ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)