Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / September 2004

Tip: Looking for answers? Try searching our database.

Can't Administer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tom Groszko - 12 Sep 2004 23:53 GMT
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.
Hilary Cotter - 13 Sep 2004 00:26 GMT
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

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

> 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
[quoted text clipped - 12 lines]
> Thanks
> Tom G.
Shallotx - 21 Sep 2004 15:53 GMT
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

> Can you verify that the MSSearch account is running under the local system
> account. Has anyone modified the SQL Server service account through the
[quoted text clipped - 39 lines]
> > Thanks
> > Tom G.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.