2012 Install - Service Accounts

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

2012 Install - Service Accounts

Author

Topic

ssimon
Starting Member

16 Posts

Posted - 2014-08-13 : 17:34:11

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

737 Posts

Posted - 2014-08-14 : 03:56:11

SQL Server service account-it is the one which runs the sql server database engine

Javeed Ahmed

ssimon
Starting Member

16 Posts

Posted - 2014-08-14 : 08:19:18

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.

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-08-20 : 07:53:16

yes, you need to create a domain account with minimum privileges for each of the services.

Javeed Ahmed

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-09-01 : 10:01:42

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources