Can't Administer

I am trying for the first time on this SQL server to use the FULL TEXT
SEARCH. I can successfully use it on other similar servers. When I try to
add a FULL TEXT CATALOG to a database I get this message when the wizard is
trying to do the work:
The Microsoft Search Service cannot be administered under the present
account.
I am logged in with an account in the Administrator group. The Search
Service is started. The server is itself is running with an account in the
Administrator group. I have checked and rechecked and everything I can think
of is the same as systems where I can make this work. I am likely missing
the obvious but can't find it. Any ideas.
Thanks
Tom G.
Can you verify that the MSSearch account is running under the local system
account. Has anyone modified the SQL Server service account through the
services applet in control panel as opposed to using EM? To fix this, right
click on your server in EM, select properties, click the security tab,
change it to run under the system account, bounce your SQL Server, and then
modify it again to run under a local admin account.
Also verify that no one has removed the builtin\admin account from the
system administrators role. To do this connect to your SQL Server in EM,
expand the security folder and expand the server roles node. Double click on
the system administrator role and ensure the builtin\administrators account
is present.
if not run the following in qa.
if not exists (select * from master.dbo.syslogins where
loginname = N'NT Authority\System')
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System',
N'us_english'
GO
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
GO
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Tom Groszko" <newscorrespondent@.charter.net> wrote in message
news:%238ktUtRmEHA.2504@.TK2MSFTNGP14.phx.gbl...
> I am trying for the first time on this SQL server to use the FULL TEXT
> SEARCH. I can successfully use it on other similar servers. When I try to
> add a FULL TEXT CATALOG to a database I get this message when the wizard
is
> trying to do the work:
> The Microsoft Search Service cannot be administered under the present
> account.
> I am logged in with an account in the Administrator group. The Search
> Service is started. The server is itself is running with an account in the
> Administrator group. I have checked and rechecked and everything I can
think
> of is the same as systems where I can make this work. I am likely missing
> the obvious but can't find it. Any ideas.
> Thanks
> Tom G.
>
|||I am curious as to whether this solved the problem. I am having the same
problem and can't seem to resolve. I am trying to execute
sp_fulltext_database in Query Analyzer and get the following error
.. Msg 7635 The Microsoft Search service cannot be administered under the
present user account
1) The builtin\admin account is a member of the System Administrators roles
2) The MSSearch service is running under a Local System account (Log On tab
in services). I have also tried the "This account" selection using a local
administrator account"
3) MSSQLSERVER service is running under a local admin account, changed
through EM per your instructions below. I have also tried running it under a
System Account.
4) I guess I am confused about what the correct combination for MSSearch
and SQL Server is with regards to accounts.
5) Any help would be greatly appreciated.
Thanks,
Tom Shalloe
"Hilary Cotter" wrote:

> Can you verify that the MSSearch account is running under the local system
> account. Has anyone modified the SQL Server service account through the
> services applet in control panel as opposed to using EM? To fix this, right
> click on your server in EM, select properties, click the security tab,
> change it to run under the system account, bounce your SQL Server, and then
> modify it again to run under a local admin account.
> Also verify that no one has removed the builtin\admin account from the
> system administrators role. To do this connect to your SQL Server in EM,
> expand the security folder and expand the server roles node. Double click on
> the system administrator role and ensure the builtin\administrators account
> is present.
> if not run the following in qa.
> if not exists (select * from master.dbo.syslogins where
> loginname = N'NT Authority\System')
> exec sp_grantlogin N'NT Authority\System'
> exec sp_defaultdb N'NT Authority\System', N'master'
> exec sp_defaultlanguage N'NT Authority\System',
> N'us_english'
> GO
> exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> GO
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Tom Groszko" <newscorrespondent@.charter.net> wrote in message
> news:%238ktUtRmEHA.2504@.TK2MSFTNGP14.phx.gbl...
> is
> think
>
>
|||Tom,
Is the master the default database for the BUILTIN\Administrator account as
well as a member of the Sysadmin role?
When you changed it to run under the System Account (LocalSystem) did you do
this via the Enterprise Manager's server security tab?
The Enterprise Manager code runs an internal system extended proc -
xp_updateFTSSQLAccount - when any change to the MSSQLServer account is
executed, this xp proc makes similar change to the MSSearch service as well.
You should review the following KB articles:
317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/default...b;en-us;317746
277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default...B;EN-US;277549
Regards,
John
"Shallotx" <Shallotx@.discussions.microsoft.com> wrote in message
news:35629999-FB98-4407-98C8-5307CF9EF861@.microsoft.com...
> I am curious as to whether this solved the problem. I am having the same
> problem and can't seem to resolve. I am trying to execute
> sp_fulltext_database in Query Analyzer and get the following error
> .. Msg 7635 The Microsoft Search service cannot be administered under
the
> present user account
> 1) The builtin\admin account is a member of the System Administrators
roles
> 2) The MSSearch service is running under a Local System account (Log On
tab
> in services). I have also tried the "This account" selection using a
local
> administrator account"
> 3) MSSQLSERVER service is running under a local admin account, changed
> through EM per your instructions below. I have also tried running it
under a[vbcol=seagreen]
> System Account.
> 4) I guess I am confused about what the correct combination for MSSearch
> and SQL Server is with regards to accounts.
> 5) Any help would be greatly appreciated.
> Thanks,
> Tom Shalloe
> "Hilary Cotter" wrote:
system[vbcol=seagreen]
right[vbcol=seagreen]
then[vbcol=seagreen]
click on[vbcol=seagreen]
account[vbcol=seagreen]
to[vbcol=seagreen]
wizard[vbcol=seagreen]
the[vbcol=seagreen]
missing[vbcol=seagreen]