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 (*** [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].
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') *** [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 =====================