[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 493
  • Last Modified:

SQL install for the first time

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
DHPBilcare
Asked:
DHPBilcare
1 Solution
 
pcelbaCommented:
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
 
DHPBilcareAuthor Commented:
Thanks

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now