locked
SCCM 2012 - Setup could not create SQL database RRS feed

  • Question

  • Whenever I try to install SCCM 2012 with SQL Server 2012 (same machine) it goes throught the install but fails at the end saying Setup could not create SQL database.

    All the prerequisite checks are good (apart from a memory allocation warning), so I cannot see what I have done wrong?

    Is there any preinstall SQL server preparation I need to do?

    Saturday, August 4, 2012 1:32 PM

Answers

All replies

  • What if you create the database prior to installing CM12


    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund

    Saturday, August 4, 2012 2:46 PM
  • Do you have sa rights on SQL server?

    Justin | http://patchmypc.net

    Saturday, August 4, 2012 3:23 PM
  • Jacob

    SQL2012 is not fully supported yet in SCCM 2012 and will install but the reporting feature of SCCM will not detect the reporting module of SQL - so in essence reporting won't work.

    However to get SQL2012 working on SCCM 2012 do the following;

    Run SQL2012 install prior to SCCM2012 install.

    Install SQL2012 logged on to the domain with a user with domain admin rights,

    Accept all defaults and select SQL Server Feature Installation,

    Select the following options;

    Use the default naming instance and click next. 

    On the server configuration tab add the domain user account for sccm for all services. You will need to add both username and password (see below)

    For both the database engine and the analysis services configuration add the current user. 

    Once the installation is complete. Open up the SQL Management Studio, login and right click on the database name and select properties then select memory. Ensure the you have entered a min and max for memory allocation. This will stop SQL Server from consuming all available memory and also remove 1 of the warnings in the setup of SCCM 2012. 

    Installation of SCCM 2012 should then be successful. 

    Thanks.

    Sunday, August 5, 2012 11:29 AM
  • No need to install the SQL replication at all. ConfigMgr does not make use of it. SQL 2012 is still unsupported though.

    Torsten Meringer | http://www.mssccmfaq.de


    • Marked as answer by Jacob Halsey Monday, August 20, 2012 1:16 PM
    • Edited by TorstenMMVP Monday, August 20, 2012 1:27 PM
    Sunday, August 5, 2012 12:20 PM
  • So the reason SCCM 2012 isn't working is because SQL 2012 is unsuported? If so why does the Supported SQL Server Version Check Prerequisite checks go through ok? I had previously read somewhere about what Matthew Thorley had said about it being supported apart from the reporting services, is this not correct then?

    Thanks

     
    Monday, August 6, 2012 4:32 PM
  • The supported configurations are listed here: http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig. SQL 2012 is not (yet) listed.

    Torsten Meringer | http://www.mssccmfaq.de

    Monday, August 6, 2012 5:38 PM
  • You can get it working (except for the reporting) but SQL 2012 is not supported. see the official requirements by Microsoft - http://technet.microsoft.com/en-US/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig

    Please note that SQL 2012 will be supported in SP1 of SCCM 2012 which is currently in beta. SP1 CTP2 is available here http://www.microsoft.com/en-us/download/details.aspx?id=30133 

    Below is taken from the above link 

    System requirements

    Supported operating systems: Windows 8 Release Preview, Windows Server 2008, Windows Server 2008 R2

    The Virtual Machine Manager server for the CTP2 release System Center 2012 SP1 will only run on Windows Server 2012 RC. For full prerequisites, see the document “Virtual Machine Manager in System Center 2012 Service Pack 1” at the following link:http://go.microsoft.com/fwlink/?LinkId=254803

    Prerequisites for Configuration Manager can be found at: http://go.microsoft.com/fwlink/?LinkId=252950.

    All other components now support Windows Server 2012 RC and SQL Server 2012 in addition to the operating systems that were supported in System Center 2012. For details on what was supported in System Center 2012, see http://go.microsoft.com/fwlink/?LinkId=255218.


    Monday, August 6, 2012 5:43 PM
  • Reporting Services are required if you need the reporting point role installed on any SCCM 2012 server.

    As stated here - 

    http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLSrvReq

    If you try and install the reporting point role on sccm2012 without the Reporting Services installed and configured on your SQL server the role installation will fail.



    Monday, August 6, 2012 5:46 PM
  • So do I need to install Reporting Services 2008 r2 or do I just have to get rid of 2012 and use 2008 r2?

    Thanks

    Tuesday, August 7, 2012 8:09 AM
  • as mentioned SQL 2012 is not yet supported at all.

    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund

    • Proposed as answer by ChrisMullins Friday, August 17, 2012 4:12 PM
    • Unproposed as answer by Jacob Halsey Friday, August 17, 2012 5:20 PM
    • Marked as answer by Jacob Halsey Monday, August 20, 2012 1:16 PM
    Tuesday, August 7, 2012 8:15 AM
  • I have installed SQL Server 2008 r2 and SP1, and all the roles Matthew Tholey posted (apart from complete management). But the prerequisite check fails under SQL Server Version!
    Thursday, August 16, 2012 5:08 PM
  • Pretty sure you also need to install one of the cumulative update packages on top of R2 SP1. I believe its Cumulative Update 6.

    http://support.microsoft.com/kb/2679367

    • Marked as answer by Jacob Halsey Monday, August 20, 2012 1:15 PM
    Thursday, August 16, 2012 11:03 PM
  • Thank you, I had though Update 6 was part of SP1! The prerequisite checks are all good, will post when it's installed and all working, I first need to do a new install since the server's in a bit of a mess since i have messed with it so much!
    Saturday, August 18, 2012 10:55 AM
  • Thank you everyone! It has all installed and is working fine.

    Monday, August 20, 2012 1:15 PM