Andrea Allred presents RoyalSQL

Bringing happy endings to all your data stories.

Tag Archives: Password

March 1, 2016 by andreaallred

I need to know that I got you with me, SQL don’t reboot on me…

Did you know that you can change the password on the SQL Service account that is running your SQL instance without a reboot or restart?  Turns out this is true.  We have a new round of password requirements and it means that we need to change passwords on servers more often. But, since we need our servers up and reboots have to be heavily planned, we needed a solution that kept us from having to restart an instance after a password change. This lovely msdn article explains all the details, but let me give you the cliffs notes.

First, standard warning: Don’t do this in production until you have tested it over and over and are completely comfortable with how it will work in your environment.

Now to the fun part: Go to SQL Server Configuration Manager, then SQL Server Services  and right click on the service on which you will be changing your password. Select Properties.

Here you are going to update the password and confirm the password and click OK.

Account Change

Guess what? That’s it! On a stand alone instance the new password will take effect immediately and as the msdn article highlights, clusters get tricky.

Happy Server Securing!

Posted in Database Feature, Security, Tools
Tagged Account, Change, No Reboot, No restart, Password, SQL, update
2 Comments

Post navigation

  • Pictures -Taken by Magic Mirrors
  • About the Royals
  • Playlist
  • SQL Server 2016 Discovery Day – SLC

News From The Kingdom

  • I’m Going Under and This Time DBCC Can’t Save Me…
  • If I need to rearrange my fragmentation, I will for you….
  • All of my friends say, “How much longer will it run?”
  • Block the impersonating menace!
  • SELECT * Is Bittersweet…I’m not trying to hurt you, I just love to query….

Enter your email address to follow this blog and receive notifications of new posts by email.

Find Your Data Story

Royals Magic

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
Blog at WordPress.com.
Cancel