locked
Configuration Manager 2012 R2 installation fails with "configuration manager 2012 setup cannot create the required database tables" RRS feed

  • Question

  • I am attempting a fresh install of SCCM 2012 R2. We have 2 servers, one primary site server and a database server.

    • Using a SQL 2012 R2 Database with SQL_Latin1_General_CP1_CI_AS collation.
    • Created an SCCM instance on the SQL 2012 R2 database server.
    • created spn's for the sccm database admin user

    When trying to install SCCM, I get the error: "Configuration manager 2012 setup cannot create the required database tables"

    I opened the ConfigMgrSetup log and found the below at the very end of the log. These are the only errors in the log.

    Anyone have any ideas?

    INFO: SQL Connection succeeded. Connection: server.domain.com SCCM\databasename, Type: Secure  $$<Configuration Manager Setup><03-20-2014 15:25:31.222+240><thread=4068 (0xFE4)>
    INFO: Importing Asset Intelligence data.  $$<Configuration Manager Setup><03-20-2014 15:25:31.223+240><thread=4068 (0xFE4)>
    INFO: SQL Connection succeeded. Connection: server.domain.com SCCM\databasename, Type: Secure  $$<Configuration Manager Setup><03-20-2014 15:25:31.224+240><thread=4068 (0xFE4)>
    INFO: Starting to import data from CSV files...  $$<Configuration Manager Setup><03-20-2014 15:25:31.224+240><thread=4068 (0xFE4)>
    INFO: Successfully created the dir  C:\Program Files\Microsoft Configuration Manager\AI~  $$<Configuration Manager Setup><03-20-2014 15:25:31.224+240><thread=4068 (0xFE4)>
    INFO: Successfully retrieved data file, now expanding  $$<Configuration Manager Setup><03-20-2014 15:25:33.487+240><thread=4068 (0xFE4)>
    INFO: Counted 9 files in AI cabfile  $$<Configuration Manager Setup><03-20-2014 15:25:33.488+240><thread=4068 (0xFE4)>
    INFO: Extracted file C:\Program Files\Microsoft Configuration Manager\AI\LU_LicensedProduct.csv  $$<Configuration Manager Setup><03-20-2014 15:25:33.492+240><thread=4068 (0xFE4)>
    INFO: Extracted file C:\Program Files\Microsoft Configuration Manager\AI\LU_Category.csv  $$<Configuration Manager Setup><03-20-2014 15:25:33.493+240><thread=4068 (0xFE4)>
    INFO: Extracted file C:\Program Files\Microsoft Configuration Manager\AI\LU_HardwareRequirements.csv  $$<Configuration Manager Setup><03-20-2014 15:25:33.495+240><thread=4068 (0xFE4)>
    INFO: Extracted file C:\Program Files\Microsoft Configuration Manager\AI\LU_MSProd.csv  $$<Configuration Manager Setup><03-20-2014 15:25:33.608+240><thread=4068 (0xFE4)>
    INFO: Extracted file C:\Program Files\Microsoft Configuration Manager\AI\LU_SoftwareCode.csv  $$<Configuration Manager Setup><03-20-2014 15:25:34.118+240><thread=4068 (0xFE4)>
    INFO: Extracted file C:\Program Files\Microsoft Configuration Manager\AI\LU_SoftwareHash.csv  $$<Configuration Manager Setup><03-20-2014 15:25:35.109+240><thread=4068 (0xFE4)>
    INFO: Extracted file C:\Program Files\Microsoft Configuration Manager\AI\LU_SoftwareList.csv  $$<Configuration Manager Setup><03-20-2014 15:25:36.015+240><thread=4068 (0xFE4)>
    ERROR(13): Failed to iterate cab file.~  $$<Configuration Manager Setup><03-20-2014 15:25:36.016+240><thread=4068 (0xFE4)>
    ERROR(13): Failed to expand the look up table files to the folder: C:\Program Files\Microsoft Configuration Manager\AI.~  $$<Configuration Manager Setup><03-20-2014 15:25:36.016+240><thread=4068 (0xFE4)>
    ERROR: Failed to import Asset Intelligence data into the site database.~  $$<Configuration Manager Setup><03-20-2014 15:25:36.016+240><thread=4068 (0xFE4)>
    ~~===================== Completed Configuration Manager 2012 Server Setup =====================  $$<Configuration Manager Setup><03-20-2014 15:25:36.019+240><thread=4068 (0xFE4)>


    Thursday, March 20, 2014 7:52 PM

Answers

  • I concur with Nash.

    Additionally, error code 13 = "The data is invalid." This is indicative of your media being corrupt. You should redownload it and verify the hash.

    Also note that there is no such product as SQL Server 2012 R2.


    Jason | http://blog.configmgrftw.com

    • Proposed as answer by Joyce L Monday, March 24, 2014 7:39 AM
    • Marked as answer by netlander Thursday, March 27, 2014 3:07 PM
    Thursday, March 20, 2014 10:23 PM
  • Went and downloaded the eval version of it, and it's installing.

    How do we tell Microsoft that their ISO's are bad?

    • Marked as answer by netlander Thursday, March 27, 2014 3:07 PM
    Thursday, March 27, 2014 3:07 PM

All replies

  • When architecting the server layout for ConfigMgr infrastructure, there are very few scenarios where it is advantageous to put the Primary Site Server on one box and the Database on a second box.  If you do not have a specific need to do so, consider putting them on one box.

    If you must put it remote, you need to ensure that both the user doing the install and the computer object of the Primary Site Server are BOTH members of the local Administrators group and have full SA privileges on the database server instance.

    Once you are sure permissions are there, ensure that the firewall rules allow communication and that authentication is succeeding (kerberos auth using your SPN).


    I hope that helps.


    Nash Pherson, Senior Systems Consultant
    Now Micro - My Blog Posts
    If you've found a bug or want the product worked differently, share your feedback.
    <-- If this post was helpful, please click "Vote as Helpful".

    • Proposed as answer by Joyce L Monday, March 24, 2014 7:39 AM
    Thursday, March 20, 2014 8:12 PM
  • I concur with Nash.

    Additionally, error code 13 = "The data is invalid." This is indicative of your media being corrupt. You should redownload it and verify the hash.

    Also note that there is no such product as SQL Server 2012 R2.


    Jason | http://blog.configmgrftw.com

    • Proposed as answer by Joyce L Monday, March 24, 2014 7:39 AM
    • Marked as answer by netlander Thursday, March 27, 2014 3:07 PM
    Thursday, March 20, 2014 10:23 PM
  • Unfortunately no. I checked all permissions before I submitted, and just rechecked them now.

    The databases are actually being created...well, the tables are, determining if there is data in any of them is a different story.

    I'd rather continue on with the remote db server, for various reasons, so I'd like to figure this out before having to reconfigure everything.

    Tuesday, March 25, 2014 5:19 PM
  • I've redownloaded the ISO several times, can you point me in the direction of where I can find the hash for it?

    Tuesday, March 25, 2014 5:22 PM
  • Oh, the R2 was a typo, had Server 2012 R2 and SCCM 2012 R2 on the brain.
    Tuesday, March 25, 2014 5:24 PM
  • The hash is typically listed on the download page.

    Jason | http://blog.configmgrftw.com

    Tuesday, March 25, 2014 7:01 PM
  • Still having same problem:

    Brand new installation: All applications installed on one server.

    I downloaded the ISO again. I do not see a hash for the ISO on the volume licensing site.

    Windows Server 2012 R2

    SQL 2012 w/SP1

    SCCM 2012 R2.

    I installed Windows Server 2012 and installed all prereq's. I then installed SQL 2012 w/SP1 and set all permissions for SCCM, including SA priveleges.

    I received the same error as before.



    • Edited by netlander Thursday, March 27, 2014 2:42 PM
    Thursday, March 27, 2014 2:39 PM
  • Went and downloaded the eval version of it, and it's installing.

    How do we tell Microsoft that their ISO's are bad?

    • Marked as answer by netlander Thursday, March 27, 2014 3:07 PM
    Thursday, March 27, 2014 3:07 PM