locked
SCCM 2012 SQL database error while installation. RRS feed

  • Question

  • Hi,

    I'm trying to install SCCM 2012 R2 in a test Lab. While completing installation I'm getting an error message "setup has encountered fatal errors during database initialization. check the log for details. click the view log button for more information" and installation finishes successfully. I'm using SQL server 2008 R2 with CU6 installed. SCCM Prerequisite checker shows only SQL memory and WSUS package warnings. Still I'm able to finish installation but not able connect SCCM. I'm installing Primary site.

    My system is running on Win 2k8 R2 SP1.

    Please help.

    Regards,

    Dhananjay


    Wednesday, April 30, 2014 12:18 PM

Answers

  • Hi All,

    Have managed to resolve this issue...

    it turned out to be an issue with SQL report viewer redistributable. I uninstalled few unidentified SQL report viewers which were displayed in Ascii characters in APPwiz.cpl. and again installed SCCM, which worked flawlessly.

    Thanks for the help.

    Cheers,

    Dhananjay

    Friday, May 2, 2014 8:57 AM

All replies

  • Any others errors in ConfigMgrSetup.log ?

    It's situated on the root of your C:\ drive.

    Wednesday, April 30, 2014 12:31 PM
  • What does the log say is the issue?

    http://www.enhansoft.com/

    Wednesday, April 30, 2014 12:33 PM
  • hi,

    PFB error message found at the end of the log file.

    WARNING: Failed to find default package file C:\SC2012_R2_SCCM_SCEP\SMSSETUP\BIN\X64\IA64_Windows_Server_2008_SP2.xml. LastError=2  $$<Configuration Manager Setup><04-30-2014 03:57:41.433+420><thread=2404 (0x964)>
    ERROR: Failed to install default configuration items (FinalSqlOperations).  $$<Configuration Manager Setup><04-30-2014 03:57:41.433+420><thread=2404 (0x964)>
    ~~===================== Completed Configuration Manager 2012 Server Setup =====================  $$<Configuration Manager Setup><04-30-2014 03:57:41.433+420><thread=2404 (0x964)>
    <04-30-2014 05:26:28> *****************************************************

    Wednesday, April 30, 2014 12:59 PM
  • Make sure the account you are installing with and the SCCM computer account are local admins and also sysadmin on the SQL server.

    Cheers

    Paul | sccmentor.wordpress.com

    Wednesday, April 30, 2014 1:13 PM
  • WARNING: Failed to find default package file C:\SC2012_R2_SCCM_SCEP\SMSSETUP\BIN\X64\IA64_Windows_Server_2008_SP2.xml. LastError=2  $$<Configuration Manager Setup><04-30-2014 03:57:41.433+420><thread=2404 (0x964)>
    *****************************************************


    Can you find that file in the source directory?

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

    Wednesday, April 30, 2014 1:28 PM
  • Odd errors like this are often due to a corrupted download of the media -- yes there have been numerous cases here in the forums and I have experienced this also. Make sure that you compare the hash of the ISO file you download with the one listed on the MVLS site.

    Jason | http://blog.configmgrftw.com

    Wednesday, April 30, 2014 1:32 PM
  • C:\SC2012_R2_SCCM_SCEP\SMSSETUP\BIN\X64\IA64_Windows_Server_2008_SP2.xml. this file exist .
    Thursday, May 1, 2014 11:34 AM
  • I will give a try to fresh copy of SCCM.
    Thursday, May 1, 2014 11:35 AM
  • Did you check your account permissions?

    Cheers

    Paul | sccmentor.wordpress.com

    Thursday, May 1, 2014 11:36 AM
  • In my experience you can get strange problems if you extract the ISO to a folder and run the setup from there (that seems to be what you have done).

    Try mounting the ISO directly and I believe you will have better success. You are using W2008R2 so you will need a 3rd party app (Virtual CloneDrive is a good one).

    (Obviously if this is a VM you can just add the ISO to the DVD drive)



    Gerry Hampson | Blog: www.gerryhampsoncm.blogspot.ie | LinkedIn: Gerry Hampson | Twitter: @gerryhampson


    Thursday, May 1, 2014 11:56 AM
  • Yes Paul.
    I have rechecked all the permission which are perfectly configured.

    One more good thing is if you have configured insufficient permissions, prerequisite checker will throw an error about it and you will not be able to continue installation.

    Friday, May 2, 2014 4:54 AM
  • Hi All,

    Have managed to resolve this issue...

    it turned out to be an issue with SQL report viewer redistributable. I uninstalled few unidentified SQL report viewers which were displayed in Ascii characters in APPwiz.cpl. and again installed SCCM, which worked flawlessly.

    Thanks for the help.

    Cheers,

    Dhananjay

    Friday, May 2, 2014 8:57 AM