Re: Can't Administer
From: Shallotx (Shallotx_at_discussions.microsoft.com)
Date: 09/21/04
- Next message: Barry Forrest: "Re: OLE DB provider 'MSIDXS' reported an error. Access denied."
- Previous message: SqlJunkies User: "RE: Remote Indexing / Distributed Query: It works.."
- In reply to: Hilary Cotter: "Re: Can't Administer"
- Next in thread: John Kane: "Re: Can't Administer"
- Reply: John Kane: "Re: Can't Administer"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 21 Sep 2004 07:53:04 -0700
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...
> > 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.
> >
> >
>
>
>
- Next message: Barry Forrest: "Re: OLE DB provider 'MSIDXS' reported an error. Access denied."
- Previous message: SqlJunkies User: "RE: Remote Indexing / Distributed Query: It works.."
- In reply to: Hilary Cotter: "Re: Can't Administer"
- Next in thread: John Kane: "Re: Can't Administer"
- Reply: John Kane: "Re: Can't Administer"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
