HELP MEEEE.... Forgot to add cluster service and remove the built-in\Adm..

  • Hello,

    I need that someone help me in this point, i forgot to add cluster service account before removing the built-in\Administrators group.

    Can anyone send me the syntax to connect to SQL Server and add the cluster service account to sysadmin.

    I always put the account into sysadmin group but this time i forgot it and now SQL Server Service dont gives up.

    Thanks and regards,

    JMSM ;o)

  • There are two solutions to your problem. One incurs an outage, the other doesn't

    Traditional solution incuring an outage

    Restart SQL Server in single user mode - http://msdn.microsoft.com/en-us/library/ms188236(SQL.90).aspx

    More information

    http://msdn.microsoft.com/en-us/library/ms190737.aspx

    http://support.microsoft.com/kb/224071

    Non outage solution

    This presumes you have made no other changes to the 'sa' role

    Rather than stopping SQL Server, starting in SQL user mode, adding your account / group and then restarting normally, simply add the principle (user / group) into the SQLServer2005MSSQLUser$ group.

    If you are already logged on as this user, then you will need to logout of your interactive Windows session and log back in before your group enumeration is updated. Then simply connect to your SQL instance via SSMS and update the 'sa' role as required. When complete, simply remove your user / group from the local SQL group.

    If you are in a cluster, then perform the above operation on the AD cluster group rather than the local group.

    --
    Andrew Hatfield

  • Hello everybody,

    Thanks for the help, but i used one simple solution :crazy:

    i locate the command prompt in the sql server bin directory and run the following command.

    Open cmd and change to SQL Server bin directory.

    Execute the following comand: sqlservr -c -f -s MyInstanceName

    Open the SQL Server Enterprise Manager and add the account to SQL Server sysadmin Group.

    cmd> sqlservr -c -f -s {instancename}

    Thanks and regards,

    JMSM 😉

Viewing 3 posts - 1 through 2 (of 2 total)

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