Post reply

How to change the sql service passwords on a SQL 2012 cluster - thanks

  • May 15, 2014 at 4:30 pm

    #286765

    Hi,

    How to change the sql service passwords on a SQL 2012 cluster - thanks

    Thanks

  • May 16, 2014 at 5:02 am

    #1714141

    APA0876 (5/15/2014)

    Hi,

    How to change the sql service passwords on a SQL 2012 cluster - thanks

    Thanks

    From the instances active node open SQL Server configuration manager.

    Change the service passwords and apply, you'll get a message stating that changes wont take effect until restart.

    Open cluster manager and take the SQL Server service offline, once done bring the SQL Server agent online (this starts the SQL Server service)

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 16, 2014 at 6:32 am

    #1714158

    Yes, that is how it is supposed to be done via Microsoft. Do NOT use the services panel to change the userid/password.

  • May 16, 2014 at 8:02 am

    #1714194

    Perry is totally 110% correct. Make sure before you restart services though that no one is working in the production environment or you will have some explaining to do lucy! lol

    Good Luck

    MCSE SQL Server 2012\2014\2016

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

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