Re: Can't Administer

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 09/12/04

  • Next message: Alexandre BARBIER: "Re: French characters on English Platform dropped" 
    Date: Sun, 12 Sep 2004 19:26:13 -0400

    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: Alexandre BARBIER: "Re: French characters on English Platform dropped"

    Relevant Pages

    • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
      ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
      (microsoft.public.sqlserver.security)
    • Re: SharePoint V3 Install Error
      ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
      (microsoft.public.sharepoint.windowsservices)
    • Re: update index in background not running.
      ... in order to allow an .net web program to access the SQL server you have to ... add IIS_WPG account to the database, ... > exec sp_defaultdb N'NT Authority\System', ...
      (microsoft.public.sqlserver.fulltext)
    • RE: Problems with WebParts
      ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
      (microsoft.public.dotnet.framework.aspnet)
    • RE: Use a Trusted Connection With OPENROWSET?
      ... The OPENROWSET is done in the context of the SQL Server account that is ... Most of the time it is the local machine account. ... > EXEC master..sp_who2') AS a ...
      (microsoft.public.sqlserver.connect)