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 sqlservercentral.mevio.com 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 www.everydayjones.com.

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: 707 | Views in the last 30 days: 5
 
Related Articles
FORUM

SERVICE ACCOUNT PASSWORD CHANGE ON CLUSTER INSTANCE

URGENT HELP= SERVICE ACCOUNT PASSWORD CHANGE ON CLUSTER INSTANCE

ARTICLE

Picking Service Accounts

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

FORUM

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

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

FORUM

SQL toolset to find the SQL service accounts and their passwords

SQL toolset to find the SQL service accounts and their passwords

FORUM

service account

Service account

Tags
editorial    
 
Contribute

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
Editor, SQLServerCentral.com

Already a member? Jump in:

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