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

  • These are the ints that never die, we reseeded negative.
  • I Made That Slow Query Run, Run, Run
  • I can query multiple instances, I am King!
  • Hit me with them good vibes, CTfP is set nice. Everything is so fire, little bit of sunshine!
  • I’m going on down to New Orleans and renaming some database things…

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.
  • Follow Following
    • Andrea Allred presents RoyalSQL
    • Join 2,028 other followers
    • Already have a WordPress.com account? Log in now.
    • Andrea Allred presents RoyalSQL
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...