Problem with Search engine access?

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!
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@.newsgroup.nospam> wrote in message
news:0C9748C6-AB94-4AC3-AEED-4F97C1FCC49B@.microsoft.com...
> 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!