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?