Solved

SQL install for the first time

Posted on 2013-11-16
2
444 Views
Last Modified: 2013-11-17
Hi,

I’m installing SQL Server 2008 R2 Standard for the first time in a Windows domain environment.
A few questions and assumption I’m making around the install.

1)  Install SQL server using the domain admin account.
2)  From the instance and shared features to install should I select all?  Are there any I don’t really need for a normal standalone instance?
3)  In terms of the SQL Services running on the server any reason why I just can’t use local system account for all of these?
4)  In account provisioning I would be recommended to use mixed mode and for Windows domain based SQL administration select a domain account with local server admin but not the domain admin account.  For SA just create a good password?

Thanks,
Martyn
0
Comment
Question by:DHPBilcare
2 Comments
 
LVL 41

Accepted Solution

by:
pcelba earned 500 total points
ID: 39653181
1) Yes
2) Install everything. It does not occupy much more additional space
3) Local system account has too high privileges. Everything you need is access to your data so user having this access and nothing else is better from security point of view.
4) This depends on your needs. Not all Windows admins know SQL Server so to have a group of SQL admins is also an option. You may disable sa account and create a new account with good password for SQL administration. It is safer.
0
 

Author Comment

by:DHPBilcare
ID: 39653272
Thanks

So for point 3 create a local server admin but not domain account for the services?
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Endpoint Protection 2 24
SSRS 2012 r2 - Parm Drop Down has Date/Time 12 31
SYbase 4 30
Script to backup a Database Dayli on SQL Server Express 3 8
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

776 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