Post reply

changing mssqlservice account- option not available using em

  • March 29, 2005 at 4:59 am

    #109458

    this is weird. i am trying to use enterprise manager to change the startuop account of a clustered sql server from "this Account" to "system" account.

    however, i noticed that the option for system account is disabled. i need to do this using enterprise manager, and not control panel, because this causes a problem for our full text catalog. this was an inherited sql server so i did not do the installation or configuration. and this is causing major CRISIS. Any ideas?

    [font="Comic Sans MS"][/font]It is what it is.

  • March 29, 2005 at 5:18 am

    #549300

    I could be wrong here but I thought that the cluster services required a domain account and thus SYSTEM would be disabled.

    LinkedIn Profile

  • March 29, 2005 at 6:56 am

    #549320

    that would certainly explain it, but here is the kicker. This is the proposed work around by microsoft, for the error, that the full text catalog is generating.

     "unable to build full-texxt catalog after  you modify mssqlserver logon through control panel."

    SQL Server 2000:

    The crawl seed <MSSQL75://SQLServer/2d12a970> in project <SQLServer SQL0000800007> cannot be accessed. Error: 8007052e - Logon failure: unknown user name or bad password. .
     

    CAUSE

    SQL Server adds itself as an Administrator to the Microsoft Search service (MSSearch). When the service logon account for the MSSQLServer service is changed through Control Panel, the service logon account no longer has administrative privileges over the MSSearch service, thus causing the error messages shown in the "Symptoms" section.

    WORKAROUND

    Steps to Reproduce Behavior

    1.Open the SQL Server Enterprise Manager. From the Action menu point to Properties, and then click Security.
    2.Change the Startup service account to System Account.
    3.Stop and then restart the MSSQLServer service.
    4.Change the Startup service account back to the domain account you want. (Make sure that you perform this task through the SQL Server Enterprise Manager and not Control Panel.)
    5.

    Stop and then restart both the MSSQLServer and MSSearch services. SQL Server should now have administrative control over the Microsoft Search service.

     

     

    ANY IDEAS?

    [font="Comic Sans MS"][/font]It is what it is.

  • March 30, 2005 at 1:34 pm

    #549649

    I would

    1. I would create a new domain account.
    2. Change the service to that account (through EM).
    3. Restart.
    4. Change the service back to the old account (through EM).
    5. Restart the service.
    6. Delete the new domain account created in 1


    Shamless self promotion - read my blog http://sirsql.net

  • April 1, 2005 at 7:23 am

    #550087

    now see. that is a great suggestion. i will let you know if it works

     

    [font="Comic Sans MS"][/font]It is what it is.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply