troubleshooting Question

sql2016-WIn10: standard,for SQL servc-account..

Avatar of 25112
25112 asked on
Microsoft SQL Server 2008
51 Comments21 Solutions463 ViewsLast Modified:
On the following screen you need to provide the service accounts that SQL Server services will use. As you can notice, SQL Server setup provides virtual accounts by default, they are auto-managed, they can access the network on a domain environment by using the credentials of the computer account.

 However, I still recommend to create a local user or use a domain user account to start SQLServer services.

Microsoft recommends you to specify an individual account for each service.

I was not able to find yet exact MSDN article that would suggest "Microsoft recommends you to specify an individual account for each service."...

what standard do you recommend/practice in this, and do you see any proc/cons either way..

this is for a local workstation on a domain, dedicated to sql2016 to connect local instance and across network.

the service is going to the same: SQLSERVER and SQLSERVERAGENT
the question is about the best or correct standard going about creating the ServiceAccount.

the sql2016 install will be done on an disk, image made and then that image will be put on 10 other PCs. (so that 11 SQL installs don't have to happen)
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 21 Answers and 51 Comments.
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>


Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 21 Answers and 51 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004