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.
