Post reply

Remotely change Services on 2005?

  • July 7, 2008 at 4:39 pm

    #129816

    We've got a SQL Server in a cluster that wouldn't let us install the tools (long sob story and don't need help with that yet), but we need to change the service account credentials on the database engine service. Without using services in Control Panel, can we get our local config tool to "register" the server and can we manage the services remotely with that tool? or is there something else that's available besides control panel, services.

    Thanks,

  • July 7, 2008 at 10:57 pm

    #839264

    Hi,

    When administering (stopping / starting / failing over etc.) a cluster SQL instance, you should use Cluster Admin.

    Books Online recommends that you use SQL Server Configuration Manager to change the Service Account. If you do use a different method, you will have to manually update NTFS file permissions and maybe some registry values...

    Checkout:

    How to: Connect to Another Computer (SQL Server Configuration Manager)

    http://technet.microsoft.com/en-us/library/ms190622.aspx

    and

    Changing Passwords and User Accounts

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

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

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