One day I was installing SCCM 2012 secondary site, I had installed SQL express on local machine because from CM12 primary site it install on C drive,
Error when doing the Prerequisite installation checks Likewise “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.”
And “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;”
Both errors were normal but I was sure I have configured correct domain account for local service, and installation account was configured as the sysadmin server roles in SQL.
After that I did, went to services and again I have reconfigured the same domain account and did stop the service and start the service of SQL server,
And SQL Agent service was by default disabled, I made this enable and automatic.
Then again I did the Prerequisite installation checks and now this time all went pass.