none
SCCM 2012 R2SP1 Database move RRS feed

  • Allgemeine Diskussion

  • Hallo

    wir versuchen verzweifelt die Datenbank vom lokalen SCCM auf unser SQL Cluster zu legen. Wir haben eine Standalone Primary Site mit 4 Secondary Sites. Beim Datenbank move erhalten wir immer folgende 2 Fehler einträge nachdem das Setup abbricht

    ERROR: Failed to create SQL Server certificate on server DE-SERVER Configuration Manager Setup 12.07.2016 08:33:42 17564 (0x449C)
    ERROR: Failed to create SQL Server [DE-SERVER] certificate remotely. Configuration Manager Setup 12.07.2016 08:33:42 17564 (0x449C)

    Der Account zum ausführen des Setups sowie das Computerkonto sind beide DomainAdmins sowie Sysadmin auf dem SQL Server.

    Ich wäre über jede hilfe dankbar.


    Dienstag, 12. Juli 2016 07:38

Alle Antworten

  • hier das ganze log

    INFO: Target computer is a 64 bit operating system. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Checking for existing setup information. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Setting setup type to  1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Checking for existing SQL information. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: 'DE- is a valid FQDN. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Verifying the registry entry for Asset Intelligence installation Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Found registry key for installation of Asset Intelligence full version Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Setup detected an existing Configuration Manager installation. Currently installed version is 8239 Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Phase is 1C7 Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    WARNING: Failed to initialize COM to get SDK Providers. It might already be initialized. return code: 80010106. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: SDK Provider is on DE-. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: SDK Provider is on DE-. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: SDK Provider is on DE-. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Setting the default CSV folder path Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: CHS, Client LangPack: 1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: CSY, Client LangPack: 1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: DEU, Client LangPack: 1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: ELL, Client LangPack: 1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: ESN, Client LangPack: 1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: FRA, Client LangPack: 1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: HUN, Client LangPack: 1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: ITA, Client LangPack: 1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: Mobile Device (INTL), LangPack: 0. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: PLK, Client LangPack: 1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: RUS, Client LangPack: 1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Language: TRK, Client LangPack: 1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Configuration Manager Build Number = 8239 Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Configuration Manager Version = 5.0 Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Configuration Manager Minimum Build Number = 800 Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Verifying Configuration Manager Active Directory Schema Extensions. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Found DS Root:CN Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Verifying Configuration Manager Active Directory Schema Extensions. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Found DS Root:CN Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: SqlMasterDB = master Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    Removed SQL alias DE- successfully. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Registered type DE- MASTER for DE-master Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Registered type SMS Master for DE- master Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Registered type DE- for DE- Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Registered type SMS ACCESS for DE- Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: 'DE- is a valid FQDN. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Run Site Maintenance on the primary site. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Checking for existing setup information. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Setting setup type to  1. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Checking for existing SQL information. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: 'DE- is a valid FQDN. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Verifying the registry entry for Asset Intelligence installation Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Found registry key for installation of Asset Intelligence full version Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: SDK Provider is on DE-. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: SDK Provider is on DE-. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: SDK Provider is on DE-. Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Retrieving current site control image... Configuration Manager Setup 12.07.2016 07:56:44 17564 (0x449C)
    INFO: Evaluating for Site Maintenance process. Configuration Manager Setup 12.07.2016 07:56:47 17564 (0x449C)
    INFO: File C:\Windows\smstsvc_test_1.exe does not exist. No zapping needed. Configuration Manager Setup 12.07.2016 07:56:47 17564 (0x449C)
    INFO: test loop count:0. Configuration Manager Setup 12.07.2016 07:56:53 17564 (0x449C)
    INFO: smstsvc_test_1 Return result <0> Configuration Manager Setup 12.07.2016 07:56:53 17564 (0x449C)
    INFO: g_SetupCmdLine.bMoveSql 1, g_SetupCmdLine.sNewSqlServer DE-, g_SetupCmdLine.sNewSqlDatabaseName S, pSetupInf->SqlMasterDB master. Configuration Manager Setup 12.07.2016 07:56:55 17564 (0x449C)
    INFO:Query on dm_os_cluster_nodes succeeded. Configuration Manager Setup 12.07.2016 07:56:55 17564 (0x449C)
    INFO: SQL Connection succeeded. Connection: DE-, Type: Unsecure Configuration Manager Setup 12.07.2016 07:56:55 17564 (0x449C)
    INFO: GetSCCMMachineLogins: login count:0. Configuration Manager Setup 12.07.2016 08:05:45 17564 (0x449C)
    INFO: GetSCCMUserLogins: login count:0. Configuration Manager Setup 12.07.2016 08:05:45 17564 (0x449C)
    INFO: Checking Service Account: Sql server:<DE->, Instance:<>, Service Account:<>. Configuration Manager Setup 12.07.2016 08:05:45 17564 (0x449C)
    Removed SQL alias DE- successfully. Configuration Manager Setup 12.07.2016 08:05:45 17564 (0x449C)
    INFO: Registered type DE-IPH-SQLC03.KNAUF.LOC SYSTEM01\MASTER for DE- Configuration Manager Setup 12.07.2016 08:05:45 17564 (0x449C)
    INFO: Registered type SMS Master for DE-IPH-SQLC03.KNAUF.LOC SYSTEM01\master Configuration Manager Setup 12.07.2016 08:05:45 17564 (0x449C)
    INFO: Registered type DE- for DE-Configuration Manager Setup 12.07.2016 08:05:45 17564 (0x449C)
    INFO: Registered type SMS ACCESS for DE-\CM_KN1 Configuration Manager Setup 12.07.2016 08:05:45 17564 (0x449C)
    INFO: SQL Connection succeeded. Connection: DE-, Type: Unsecure Configuration Manager Setup 12.07.2016 08:05:45 17564 (0x449C)
    INFO: SQL Server DE-is clustered. Configuration Manager Setup 12.07.2016 08:05:45 17564 (0x449C)
    INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure Configuration Manager Setup 12.07.2016 08:05:46 17564 (0x449C)
    INFO: Stopping console applications that may interfere with uninstallation... Configuration Manager Setup 12.07.2016 08:05:47 17564 (0x449C)
    INFO: Closing System Center Configuration Manager console. Configuration Manager Setup 12.07.2016 08:05:47 17564 (0x449C)
    INFO: Completed stopping console applications. Configuration Manager Setup 12.07.2016 08:05:47 17564 (0x449C)
    INFO: SQL Server Native Client: SQLNCLI11 version:<11.2.5058.0> Configuration Manager Setup 12.07.2016 08:05:47 17564 (0x449C)
    INFO: Installing msxml60 Configuration Manager Setup 12.07.2016 08:05:47 17564 (0x449C)
    INFO: Executing Command <msiexec.exe /i "D:\ConfigMgr_InstallSources\R2SP1\Download_Files\msxml6_x64.msi" /quiet /norestart>. Configuration Manager Setup 12.07.2016 08:05:47 17564 (0x449C)
    INFO: D:\ConfigMgr_InstallSources\R2SP1\Download_Files\msxml6_x64.msi installation process returned 0. Configuration Manager Setup 12.07.2016 08:05:48 17564 (0x449C)
    INFO: Installing SQL Common Language Runtime types Configuration Manager Setup 12.07.2016 08:05:48 17564 (0x449C)
    INFO: Executing Command <msiexec.exe /i "D:\ConfigMgr_InstallSources\R2SP1\Download_Files\SQLSysClrTypes.msi" /quiet /norestart>. Configuration Manager Setup 12.07.2016 08:05:48 17564 (0x449C)
    INFO: D:\ConfigMgr_InstallSources\R2SP1\Download_Files\SQLSysClrTypes.msi installation process returned 0. Configuration Manager Setup 12.07.2016 08:05:48 17564 (0x449C)
    INFO: Installing SQL Server Shared Management Objects Configuration Manager Setup 12.07.2016 08:05:48 17564 (0x449C)
    INFO: Executing Command <msiexec.exe /i "D:\ConfigMgr_InstallSources\R2SP1\Download_Files\SharedManagementObjects.msi" /quiet /norestart>. Configuration Manager Setup 12.07.2016 08:05:48 17564 (0x449C)
    INFO: D:\ConfigMgr_InstallSources\R2SP1\Download_Files\SharedManagementObjects.msi installation process returned 0. Configuration Manager Setup 12.07.2016 08:05:50 17564 (0x449C)
    INFO: Setting -T8295 SQL Server Param already exists. Configuration Manager Setup 12.07.2016 08:05:50 17564 (0x449C)
    INFO: Setting -T4199 SQL Server Param already exists. Configuration Manager Setup 12.07.2016 08:05:50 17564 (0x449C)
    INFO: Creating SQL Server machine certificate for Server [DE-IPH-SQLC03.KNAUF.LOC]... Configuration Manager Setup 12.07.2016 08:05:50 17564 (0x449C)
    INFO: 'DE-is a valid FQDN. Configuration Manager Setup 12.07.2016 08:05:50 17564 (0x449C)
    ERROR: Failed to create SQL Server certificate on server DE- Configuration Manager Setup 12.07.2016 08:33:42 17564 (0x449C)
    ERROR: Failed to create SQL Server [DE-] certificate remotely. Configuration Manager Setup 12.07.2016 08:33:42 17564 (0x449C)


    • Bearbeitet M_Adam89 Dienstag, 12. Juli 2016 07:45
    Dienstag, 12. Juli 2016 07:39
  • Hilft das weiter? https://blogs.technet.microsoft.com/sheyia/2015/01/01/configuration-manager-2012-install-error-failed-to-create-machine-certificate-on-server/

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

    Dienstag, 12. Juli 2016 07:49
    Beantworter
  • danke. aber leider nein. wir haben schon unzählige lösungsvorschläge und ähnliches versucht. wir haben keine rote zeile mehr im log ausser die letzten 2. SQL Thumbprint angelegt alles....
    Donnerstag, 14. Juli 2016 06:36