locked
Config Manager 2012 R2 setup fails with SQL server with error RRS feed

  • General discussion

  • Hi, 

    We are setting a Config manager 2012 R2 and have SQL Server 2012 SP1. While installing config manager 2012 R2, somehow it doesn't connects with the SQL instance. Config manager and SQL servers are on same machine. I have configured static port as 1433 for SQL  based http://blogs.technet.com/b/aviraj/archive/2013/05/14/system-center-2012-sp1-configuration-manager-sccm-2012-installation-sql-server-database-error-when-using-named-instance.aspx. even this doesn't help then i started SQL browser service (it was in stop state), now error has changed to 

    If i check Configmgrsetupwizard.log It says creating sql connection...and then sql connection is established

    If i check configmgrsetup.log, it has errors like

    

    Any pointers will be appreciated. Thanks in advance

    Regards

    Saturday, August 23, 2014 8:38 PM

All replies

  • Hi,

    Have you installed all current updates for the SQL Instance that you wish to use for ConfigMgr? Specifically CU2 for SQL 2012 at a minimum.

    Saturday, August 23, 2014 8:41 PM
  • The supported SQL configurations are clearly listed at http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig For ConfigMgr 2012 R2, SQL 2012 SP1 (no CU) is sufficient.

    First the sanity check: Are you sure you have SQL Server 2012 SP1 installed?

    If so, then these types of errors are often caused by lack of permissions. The account you installing the site server with must be *both* a local admin on the system hosting you SQL instance and sys admin in that SQL instance. The site server's AD computer must also be both of these as well.

    Finally though, why are you using a remote SQL instance at all? Using a local SQL instance is far better for many reasons including simplicity, performance (for small to medium sites), and security.


    Jason | http://blog.configmgrftw.com | @jasonsandys

    Saturday, August 23, 2014 10:01 PM
  • Hi Thanks for reply guys

    It must be SQL 2012 SP1 since i see version shown as 11.0.3000.0 on my SQL Server  (http://support.microsoft.com/kb/321185/en-gb). 

    service account used for installation is both are already added as Local admin and sys admin in the SQL instance. site server AD account is also added as both local Admin as well as SQL sysadmin in the SQL instance. Error still persist. Firewall is also disabled. 

    Configuration manager and SQL are on the same machine. 

    Since it is a VM, i have reinstalled eveything on VM including OS but stuck again at the same issue. 

    Any further pointers...pls. 

    Regards,

    Sunday, August 24, 2014 2:00 PM