SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 2012 Install - Service Accounts
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ssimon
Starting Member

USA
16 Posts

Posted - 08/13/2014 :  17:34:11  Show Profile  Visit ssimon's Homepage  Reply with Quote
I have been tasked to install 2012 on a new machine which we will move current 2008 R2 database over too (approx. 26). This machine will also hold a new instance of SharePoint (not sure if this makes any difference).

I have gone through the setup.exe process up to Service Accounts tab to see what accounts are needed: (They are:)

1. SQL Server Agent
2. SQL Server Database Engine
3. SQL Server Reporting Services
4. SQL Server Integration Services 11.0
5. SQL Server Browser

It is my understanding that I should at least create two basic AD accounts (like sqluser1, sqluser2). One AD account to be a local admin on the new server and to be the account that installs the SQL (I also read that afterwards I should disable the account - not delete just disable--??). The Second AD account should just be a regular AD account.

???????????

So from the above I would guess the following (Please any help)
1. = sqluser1
2. = sqluser2
3. = sqluser2
4. = sqluser2
5. = sqluser2
???????????


Also - I see a lot of people talking about "SQL Server service account" - which account is this talking about?

Thanks for any advice,
ssimon
(Accidental DBA)

ahmeds08
Aged Yak Warrior

India
649 Posts

Posted - 08/14/2014 :  03:56:11  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
SQL Server service account-it is the one which runs the sql server database engine

Javeed Ahmed
Go to Top of Page

ssimon
Starting Member

USA
16 Posts

Posted - 08/14/2014 :  08:19:18  Show Profile  Visit ssimon's Homepage  Reply with Quote
Javeed,
Thank you for your reply.

So maybe:
1. = sqluser2
2. = sqluser1
3. = sqluser1
4. = sqluser1
5. = sqluser1

??

Do I need a AD user for each one? Which one needs to be Admin of the local machine? This machine will be access across a world wide network.
Go to Top of Page

ahmeds08
Aged Yak Warrior

India
649 Posts

Posted - 08/20/2014 :  07:53:16  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
yes, you need to create a domain account with minimum privileges for each of the services.

Javeed Ahmed

Edited by - ahmeds08 on 08/20/2014 07:57:30
Go to Top of Page

Shanky
Starting Member

United Kingdom
48 Posts

Posted - 09/01/2014 :  10:01:42  Show Profile  Reply with Quote
Please read
http://msdn.microsoft.com/en-gb/library/ms143504.aspx

Hope this helps

Regards
Shanky
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.33 seconds. Powered By: Snitz Forums 2000