I have been trying on and off the past couple of days to get SCCM 2012 to install in my small environment (50 systems). I have resolved all of the prerequisites except for those in regards to SQL. I'm getting the following (my attempts to resolve the issues are bold):
The logon account for the SQL Server service cannot be a local user account or LOCAL SERVICE. You must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM.
The instance of SQL has been set to run as domain\sccm (service account), but error still shows up.
Configuration Manager requires that you configure your SQL Server instance and Configuration Manager site database (if already present) to use the SQL_Latin1_General_CP1_CI_
AS collation, unless you are using a Chinese operating system and require GB18030 support. For information about changing your SQL Server instance and database collations, see http://go.microsoft.com/fwlink/p/?LinkID=234541
. For information about enabling GB18030 support, see http://go.microsoft.com/fwlink/p/?LinkId=234542
I've confirmed through multiple installs of SQL 2008 R2 that the proper collation is used
Either the user account running Configuration Manager Setup does not have sysadmin SQL Server role permissions on the SQL Server instance selected for site database installation, or the SQL Server instance could not be contacted to verify permissions. Setup cannot continue.
During the install of SQL 2008 R2 I specified the computer account (domain\SCCM$) and domain\sccm (service account) have sysadmin rights
I thought that it might have to do with the version of SQL I'm using, say lacking a CU. I'm running SQL 2008 R2 10.50.4000 which I believe equates to 20008 R2 w/SP2 and no CU. This is a supported version according to here:http://technet.microsoft.com/en-us/library/gg682077.aspx
Any ideas what the problem could be?