Solved

SQL install for the first time

Posted on 2013-11-16
2
456 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

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…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

740 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