November 21, 2008 at 2:49 pm
We are in the process of changing the account we use for starting up SQL Server and SQL Agent. We've been using the domain administrator but understand that is not a good practice. Our consultant recommended using the local system account but I read this is also not a best practice. With that in mind what do people use? I've read to use a domain account and make it a member of the sysadmin role which we can do however we have a number of sql servers. Do people create new domain accounts for each server for security purposes or is it recommended to use a general account, e.g. domain\OurNameSQLServer, and use this account for the startup service account on all our sql servers. Any advice is greatly appreciated. Thanks you.
November 21, 2008 at 3:12 pm
We use a general domain\OurNameSQLServer account with SysAdmin privilege...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply