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

Unable to Start SCCM ConfigMgr CB Setup Installation Invalid object name SetupInfo Configuration Manager? I stumbled across one issue where I can’t even proceed to the 2nd page of the 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”.

Introduction – Unable to Start SCCM ConfigMgr CB Setup Installation Invalid object

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 installation wizard was not allowed to proceed to the second page. Now I’m stuck. Even I didn’t find any installation traces in “Control Panel – Add Remove Programs”. So the only thing left was the registry key.

Patch My PC

I found setup had created SMS keys under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS. I exported those keys (just in case) and then deleted them. Tried to run the SCCM CB setup again. It worked like a champ!

Error Details – Setup Installation Invalid object name SetupInfo

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 Unable to Start SCCM ConfigMgr CB Setup Installation Invalid object name SetupInfo Configuration Manager
SCCM CB Installation Failure Unable to Start SCCM ConfigMgr CB Setup Installation Invalid object name SetupInfo Configuration Manager

Solution – Unable to Start SCCM ConfigMgr CB Setup Installation Invalid object

Details of SCCM CB SQL DB creation errors mentioned above:- we’ve re-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.

1E Nomad
*** 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 =====================

Resources

Learn Microsoft Intune Related Posts Real World Experiences (anoopcnair.com)

SCCM Related Posts Real World Experiences Of SCCM Admins (anoopcnair.com)

Intune Device Management – HTMD Blog #2 (howtomanagedevices.com)

6 thoughts on “Unable to Start SCCM ConfigMgr CB Setup Installation Invalid object name SetupInfo Configuration Manager”

  1. Thanks Anoop, I was installing 2103 with SQLAlwaysOn, I pointed the installer to the secondary node by accident, this fix works perfect

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.