Advertisement

Unable to Start SCCM ConfigMgr CB Setup Installation Invalid object name SetupInfo

I stumbled across one issue where I can’t even proceed to 2nd page of SCCM / ConfigMgr Current Branch (CB) installation wizard. Moreover it was giving me SQL related error/s (ConfigMgrSetupWizard Error: 1 : Exception message: [Invalid object name ‘SetupInfo’.], Exception details: [System.Data.SqlClient.SqlException (0x80131904): Invalid object name ‘SetupInfo’.) in “ConfigMgrSetupWizard.log”. I tried restarting the server without any luck. Initially, when I tried to install the SCCM CB primary server I got a Database creation error (*** [42000][5170][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot create file ‘P:\DBSQL\MSSQL12.MSSQLSERVER\MSSQL\DATA\CM_AN1.mdf’ because it already exists.) and I was giving a retry. However the SCCM CB instalaltion wizard was not allowing to proceed to second page. Now I’m stuck. Even I didn’t find any installation traces in “COntrol Panel – Add Remove Programs”. So only thing left was registry key. I found setup had created SMS keys under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS. I exported those keys (just incase) and then deleted it. Tried to run the SCCM CB setup again. It worked like a champ !

Error Details :-

ConfigMgrSetupWizard Information: 1 : Sql connection is established.
ConfigMgrSetupWizard Error: 1 : Exception message: [Invalid object name 'SetupInfo'.], Exception details: [System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'SetupInfo'.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at  system.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
Error Number:208,State:1,Class:16].
SCCM CB Installation Failure

SCCM CB Installation Failure

Details of SCCM CB SQL DB creation errors mentioned above :- we’ve pre created the DataFiles and Transaction log files as per the best practices with the recommended size. There were multiple data files and transaction log files as per the vCPU or CPU count of the SCCM CB server. For testing I detached the created DB base along with files for testing and forgot to attach the SQL DB (before running the SCCM CB setup wizard). That was the root cause for the following error.

*** CREATE DATABASE [CM_AN1] ON ( NAME=CM_AN1,FILENAME='P:\DBSQL\MSSQL12.MSSQLSERVER\MSSQL\DATA\CM_AN1.mdf') LOG ON ( NAME=CM_GW1_log,FILENAME='G:\DBSQL\MSSQL12.MSSQLSERVER\MSSQL\Data\CM_GW1_log.ldf')
*** [42000][5170][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot create file 'F:\DBSQL\MSSQL12.MSSQLSERVER\MSSQL\DATA\CM_GW1.mdf' because it already exists. Change the file path or the file name, and retry the operation.
INFO: Executing SQL Server command: <CREATE DATABASE [CM_AN1] ON ( NAME=CM_AN1,FILENAME='P:\DBSQL\MSSQL12.MSSQLSERVER\MSSQL\DATA\CM_AN1.mdf') LOG ON ( NAME=CM_AN1_log,FILENAME='Q:\DBSQL\MSSQL12.MSSQLSERVER\MSSQL\Data\CM_AN1_log.ldf')>
ERROR: Failed to create database 'CM_AN1'.
ERROR: Init_Database - Failed to create database.
~===================== Completed Configuration Manager 2012 Server Setup =====================

About Author 

Anoop is Microsoft MVP and Veeam Vanguard ! He is a Solution Architect on enterprise client management with more than 13 years of experience (calculation done on the year 2014) in IT. He is Blogger, Speaker and Local User Group Community leader. His main focus is on Device Management technologies like SCCM 2012,Current Branch, Intune. He writes about the technologies like SCCM, SCOM, Windows 10, Azure AD, Microsoft Intune, RMS, Hyper-V etc...

    Find more about me on:
  • googleplus
  • twitter
  • facebook
  • linkedin
  • youtube
Posted in: ConfigMgr (SCCM), Configmgr2012, Console, SCCM 2016, SCCM CB

Leave a Comment and Contact Anoop