[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL install for the first time

Posted on 2013-11-16
2
Medium Priority
?
487 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 43

Accepted Solution

by:
pcelba earned 2000 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

649 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