Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Service Accounts

By Steve Jones,

Most of us deal with service accounts when we setup a new instance of SQL Server. While some other OS level tasks might be delegated to system administrators, usually it's the DBA that has to pick and implement the service accounts.

I've always been a fan of choosing a complicated, one-time password for service accounts, something that is hard to crack since these often are privileged accounts, at least within SQL Server. And since they rarely change in my experience, I had a question this Friday:

Do You Need To Keep Service Account Passwords?

My short answer is "No." You don't need to remember, write down, or otherwise record the service account password. You generate it, type it into the service account dialog, and forget it. If you need to test something as the service account, say some service or permissions, you either create a new account with the same groups for permissions or you set a new service account password.

However I'm sure that some of you might have reasons that you should keep the password handy for some reason and I'd like to know what you think.

Steve Jones

The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are now available at to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

Total article views: 747 | Views in the last 30 days: 4
Related Articles




Picking Service Accounts

It is something you do rarely, but with SQL Server 2005 and ten services, there are more decisions t...


Please Help:How to change the sql service account password on active/active.

How to change the sql service account password on active/active


SQL toolset to find the SQL service accounts and their passwords

SQL toolset to find the SQL service accounts and their passwords


service account

Service account


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones