SQL server database has user defined objects, cannot configure database

Just stood up a svr ent 2008 R2 w/SP1, attempting to install Central management Site for SCCM 2012.

Encountered the following error: "SQL server database has user defined objects, cannot configure database".

The database that was chosen by SCCM 2012 does not appear on the SQL server.  Not sure what went wrong.

April 30th, 2012 5:57pm

Are you pre-creating a database or letting the installer create it?
May 1st, 2012 2:32pm

Refer ConfigMgrSetup.log to get a more detailed error message.
Free Windows Admin Tool Kit Click here and download it now
May 1st, 2012 3:03pm

Setup is basically telling you that the database specified already exists and is not empty - it has tables, sprocs, views  and/or other objects.  A very common way that happens is that a previous setup failed after configuring the database at least partially and left the database behind.  Usually setup creates the database in the default case so just manually choosing a different name of a database that does not exist usually works around the issue.  There could be something else going on as well but that is a common cause and solution.
May 2nd, 2012 8:11pm

I Delete this SQL instace and install new. fter that SCCM installed correctly.
  • Marked as answer by smadge Monday, March 09, 2015 3:51 PM
Free Windows Admin Tool Kit Click here and download it now
May 3rd, 2012 9:48am

Hi There,

I am getting same error SQL Server Database has user defined objects, cannot configure database

Did you had any problems when deleting and recreating default SQL instance? wondering if primary sites would have problems connecting back to CAS. 


April 17th, 2015 6:34pm

Hi There,

I am getting same error SQL Server Database has user defined objects, cannot configure database

Did you had any problems when deleting and recreating default SQL instance? wondering if primary sites would have problems connecting back to CAS. 


  • Edited by goodyonetwo Friday, April 17, 2015 10:32 PM
Free Windows Admin Tool Kit Click here and download it now
April 17th, 2015 10:31pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics