Solved

SQL Server Installation - Service Accounts

Posted on 2013-06-05
1
352 Views
Last Modified: 2013-06-05
Installing Developer Edition of SQL Server.  

On "Server Configuration" - what should I select for account name?

A user account, network service, or system?

(generic image)
SQL Server
0
Comment
Question by:patriotpacer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 8

Accepted Solution

by:
didnthaveaname earned 500 total points
ID: 39223228
I think the following is a good conversation on the scenarios when each are appropriate:

http://blogs.technet.com/b/canitpro/archive/2012/02/08/the-sql-guy-post-15-best-practices-for-using-sql-server-service-accounts.aspx

I think the underlying message is never use network service or local system accounts.

Edit:

One thing that is not mentioned in the link I posted are extensions of the domain accounts.

In Windows Server 2012, you have Group Managed Service Accounts (http://blogs.technet.com/b/askpfeplat/archive/2012/12/17/windows-server-2012-group-managed-service-accounts.aspx, which are far better than the 2008r2 Managed Service Accounts.  The requirements for GMSAs are a little odd (not dependent on domain/forest functional levels), so if you'd like to play with them, check out: http://technet.microsoft.com/en-us/library/hh831782.aspx
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question