Solved

SQL install for the first time

Posted on 2013-11-16
2
462 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
[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
2 Comments
 
LVL 42

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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

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…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

734 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