Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Full Text / Microsoft Search Error

Author  Topic 

evjo
Starting Member

20 Posts

Posted - 2006-12-10 : 23:27:31
Hi All,

I am trying to run the "EXEC sp_fulltext_database 'enable'" procedure against a database on one of our development servers and I get the following error.

"The Microsoft Search service cannot be administered under the present user account"

Originally both services (MSSQLServer & Microsoft Search) were set to run on "Local System account", and builtin\administrators had sysadmin privileges on the server.

I then set both to run under a local administrator account, and still no love.

Any clues?

Does anyone have any idea?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-11 : 01:10:26
Through which login you are executing the SP? Windows Authentication?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

evjo
Starting Member

20 Posts

Posted - 2006-12-11 : 01:59:44
Yeah it was, I have found the solution, basically it was a corrupt registry entry. I found the fix at:
[url]http://groups.google.com/group/microsoft.public.sqlserver.fulltext/msg/7cb7c7692a0e2ff1?hl=en&lr=&ie=UTF-8&oe=UTF-8[/url]


I now have a different problem, but I will save this for a different thread.
Go to Top of Page
   

- Advertisement -