Solved

SQL Server Installation - Service Accounts

Posted on 2013-06-05
1
342 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
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Find results from sql within a time span 11 32
Sql server, import complete table, using vb.net 9 35
SQL View nearest date 5 36
Better way to make a query with date filter. 5 27
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

777 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