[Résolu]Installation SCE 2007 : Erreur SQL Server Reporting

par **marcolefo** sur Mar 29 Jan 2008, 11:36

Bonjour,

Il m'est impossible d'installer System center essential sur un windows 2003 SP2. En effet l'installation plante sur SQL Server 2005 Reporting Services.

Code: Tout sélectionner: Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790) Time : Tue Jan 29 11:10:00 2008 Machine : GARULFO Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : GARULFO Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_OWC11_1.log -------------------------------------------------------------------------------- Machine : GARULFO Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1704 Install : Successful Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_BackwardsCompat_1.log -------------------------------------------------------------------------------- Machine : GARULFO Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : GARULFO Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : GARULFO Product : Microsoft SQL Server VSS Writer Product Version : 9.00.2047.00 Install : Successful Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : GARULFO Product : MSXML 6.0 Parser (KB933579) Product Version : 6.10.1200.0 Install : Successful Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_MSXML6_1.log -------------------------------------------------------------------------------- Machine : GARULFO Product : Microsoft SQL Server 2005 Product Version : 9.1.2047.00 Install : Successful Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_SQL.log -------------------------------------------------------------------------------- Machine : GARULFO Product : Reporting Services Error : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Erreur irrécupérable lors de l'installation. -------------------------------------------------------------------------------- Machine : GARULFO Product : Reporting Services Error : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Erreur irrécupérable lors de l'installation. -------------------------------------------------------------------------------- Machine : GARULFO Product : Microsoft SQL Server 2005 Reporting Services Product Version : 9.1.2047.00 Install : Failed Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_RS.log Last Action : InstallFinalize Error String : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Erreur irrécupérable lors de l'installation. Error Number : 29528 -------------------------------------------------------------------------------- SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt. Time : Tue Jan 29 11:20:38 2008 List of log files: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_Core(Local).log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_SQLSupport_1.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_OWC11_1.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_BackwardsCompat_1.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_SQLSupport_2.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_SQLNCLI_1.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_SqlWriter_1.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_MSXML6_1.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_SQL.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_RS.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_Datastore.xml C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_.NET Framework 2.0.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_Support.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_Core.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0019_GARULFO_SCC.log

J'ai fait une petite recherche sur le forum et j'ai trouvé ceci :
http://www.forum-microsoft.org/topic100357-15.html

J'ai donc patché le DVD d'installation avec ça :
http://www.microsoft.com/downloads/deta ... laylang=en

Le problème reste le même.

Quelqu'un a une idée ?

par **marcolefo** sur Ven 01 Fév 2008, 15:50

Bon pour m'assurer que cela ne venait pas du fait que mon serveur avait été, il y a quelques temps, contrôleur de domaine, j'ai tenté l'install sur un système tout neuf.

Le log n'est pas le même, mais le résultat si

. Je ne poste pas le log entier, car il est énorme, mais voici un bout, qui pourrait être une piste :

Code: Tout sélectionner: ... MSI (s) (E8:CC) [14:47:42:761]: Target path resolution complete. Dumping Directory table... MSI (s) (E8:CC) [14:47:42:761]: Note: target paths subject to change (via custom actions or browsing) MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: TARGETDIR , Object: C:\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: WindowsFolder , Object: C:\WINDOWS\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: ProgramFilesFolder , Object: C:\Program Files\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: INSTALLDIR , Object: C:\Program Files\System Center Essentials 2007\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: TOOLS.68918168_3885_4F75_BBF8_0CC84213F8D1 , Object: C:\Program Files\System Center Essentials 2007\Tools\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: REPORTINGDIR , Object: C:\Program Files\System Center Essentials 2007\Reporting\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: SRSFILEFOLDER , Object: C:\Program Files\System Center Essentials 2007\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: SDK_DIR.9B663534_CD9B_41CC_9D93_4E84D3C5E165 , Object: C:\Program Files\System Center Essentials 2007\Reporting\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: REPORTSFOLDER.9B663534_CD9B_41CC_9D93_4E84D3C5E165 , Object: C:\Program Files\System Center Essentials 2007\Reporting\Reports\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: DWReportLibrary.9B663534_CD9B_41CC_9D93_4E84D3C5E165 , Object: C:\Program Files\System Center Essentials 2007\Reporting\Reports\Microsoft.SystemCenter.DataWarehouse.Report.Library\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: DatabaseModuleDir.128A4B6A_C876_40B8_83B5_2793414E2138 , Object: C:\Program Files\System Center Essentials 2007\Reporting\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: DATABASE_DIR , Object: C:\Program Files\System Center Essentials 2007\Reporting\Database\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: SQLROOTDATADIR , Object: C:\Program Files\System Center Essentials 2007\Reporting\MSSQL\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: TempLogDir , Object: C:\Program Files\System Center Essentials 2007\Reporting\MSSQL\data\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: TempDataDir , Object: C:\Program Files\System Center Essentials 2007\Reporting\MSSQL\data\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: DB_LOG_DIR , Object: C:\Program Files\System Center Essentials 2007\Reporting\MSSQL\data\ MSI (s) (E8:CC) [14:47:42:761]: Dir (target): Key: DB_DATA_DIR , Object: C:\Program Files\System Center Essentials 2007\Reporting\MSSQL\data\ MSI (s) (E8:CC) [14:47:42:792]: skipping installation of assembly component: {CFABE426-FF84-4FA5-9BB8-610F525B6CCA} since the assembly already exists Début de l'action [Time : [1]. MSI (s) (E8:CC) [14:47:42:792]: Doing action: _ValidateSRSWebSiteBindingsCA Fin de l'action 14:47:42 : CostFinalize. Valeur renvoyée : 1. MSI (s) (E8:DC) [14:47:42:808]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI38D.tmp, Entrypoint: ValidateSRSWebSiteBindingsCA Début de l'action [Time : [1]. CAPACK: Extracting custom action to temporary directory: C:\WINDOWS\Installer\MSI38D.tmp-\ CAPACK: Binding to CLR version v2.0.50727 MSI (s) (E8!08) [14:47:43:339]: PROPERTY CHANGE: Adding REPORT_SERVER_FULL_HTTP_PATH_VALID property. Its value is '0'. Calling custom action ReportingCAManaged!Microsoft.Reporting.Setup.ReportingManagedCAs.ValidateSRSWebSiteBindingsCA MSI (s) (E8!08) [14:47:52:106]: PROPERTY CHANGE: Modifying REPORT_SERVER_FULL_HTTP_PATH_VALID property. Its current value is '0'. Its new value: '1'. ValidateSRSWebSiteBindingsCA: Found a responsive web site at http://APIS:80/ReportServer$SCE MSI (s) (E8:CC) [14:47:52:168]: Doing action: _SetPropertiesToManagementServerDatabaseCA Fin de l'action 14:47:52 : _ValidateSRSWebSiteBindingsCA. Valeur renvoyée : 1. MSI (s) (E8:30) [14:47:52:184]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI391.tmp, Entrypoint: SetPropertiesToManagementServerDatabaseCA Début de l'action [Time : [1]. CAPACK: Extracting custom action to temporary directory: C:\WINDOWS\Installer\MSI391.tmp-\ CAPACK: Binding to CLR version v2.0.50727 Calling custom action ReportingCAManaged!Microsoft.Reporting.Setup.ReportingManagedCAs.SetPropertiesToManagementServerDatabaseCA SetPropertiesToManagementServerDatabaseCA: MOM Server FQDN is: apis.info.prive MSI (s) (E8!18) [14:47:58:325]: PROPERTY CHANGE: Adding MGSQLSERVER property. Its value is 'APIS\SCE'. MSI (s) (E8!18) [14:47:58:325]: PROPERTY CHANGE: Adding MGDATABASE property. Its value is 'OperationsManager'. SetPropertiesToManagementServerDatabaseCA: Found the Management Server Database Information. MSI (s) (E8:CC) [14:47:58:372]: Doing action: _SetPropertiesToManagementServerActionAndSDKAccountCA Fin de l'action 14:47:58 : _SetPropertiesToManagementServerDatabaseCA. Valeur renvoyée : 1. MSI (s) (E8:58) [14:47:58:419]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI393.tmp, Entrypoint: SetPropertiesToManagementServerActionAndSDKAccountCA Début de l'action [Time : [1]. CAPACK: Extracting custom action to temporary directory: C:\WINDOWS\Installer\MSI393.tmp-\ CAPACK: Binding to CLR version v2.0.50727 Calling custom action ReportingCAManaged!Microsoft.Reporting.Setup.ReportingManagedCAs.SetPropertiesToManagementServerActionAndSDKAccountCA MSI (s) (E8!9C) [14:48:04:685]: PROPERTY CHANGE: Adding MGACTIONS_DOMAIN property. Its value is 'INFORMATIQUE'. SetPropertiesToManagementServerActionAndSDKAccountCA: MOM Server FQDN is: apis.info.prive MSI (s) (E8!9C) [14:48:09:639]: PROPERTY CHANGE: Adding UnableToGetUserNameFromManagementServerActionAccount property. Its value is 'SetPropertiesToManagementServerActionAndSDKAccountCA error: Microsoft.EnterpriseManagement.Common.UnauthorizedAccessMonitoringException : Le domaine spécifié n'existe pas ou ne peut pas être contacté.'. MSI (s) (E8!9C) [14:48:09:639]: PROPERTY CHANGE: Adding UnableToGetUserNameFromManagementServerSDKAccount property. Its value is 'SetPropertiesToManagementServerActionAndSDKAccountCA error: Microsoft.EnterpriseManagement.Common.UnauthorizedAccessMonitoringException : Le domaine spécifié n'existe pas ou ne peut pas être contacté.'. SetPropertiesToManagementServerActionAndSDKAccountCA error: Microsoft.EnterpriseManagement.Common.UnauthorizedAccessMonitoringException : Le domaine spécifié n'existe pas ou ne peut pas être contacté. StackTrace: à Microsoft.EnterpriseManagement.DataAbstractionLayer.SdkDataAbstractionLayer.HandleIndigoExceptions(Exception ex) à Microsoft.EnterpriseManagement.DataAbstractionLayer.AdministrationOperations.GetServiceAccount() à Microsoft.EnterpriseManagement.Administration.ManagementGroupAdministration.GetServiceAccount() à Microsoft.Reporting.Setup.ReportingManagedCAs.GetManagementServerSDKAccount(String momServerFQDN, String& sdkServiceDomainAndAccount) à Microsoft.Reporting.Setup.ReportingManagedCAs.SetPropertiesToManagementServerActionAndSDKAccountCA(Session session) Fin de l'action 14:48:09 : _SetPropertiesToManagementServerActionAndSDKAccountCA. Valeur renvoyée : 3. Fin de l'action 14:48:09 : INSTALL. Valeur renvoyée : 3. ...

On y décèle :

Code: Tout sélectionner: MSI (s) (E8!9C) [14:48:09:639]: PROPERTY CHANGE: Adding UnableToGetUserNameFromManagementServerActionAccount property. Its value is 'SetPropertiesToManagementServerActionAndSDKAccountCA error: Microsoft.EnterpriseManagement.Common.UnauthorizedAccessMonitoringException : Le domaine spécifié n'existe pas ou ne peut pas être contacté.'.

J'ai essayé de sortir ma machine du domaine, puis de la réinscrire, pas de changement.

Dans l'observateur d'événement, je n'ai aucun message d'erreur.

Je désespère.

par **marcolefo** sur Ven 01 Fév 2008, 16:22

Une piste

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

J'attend le mail de microsoft pour télécharger le patch.

par **marcolefo** sur Ven 01 Fév 2008, 17:28

Youpi !

Il semble donc que le problème est que le nom NetBios de mon domaine diffère de sa version "complète" (fully qualified domain name - FQDN).

Après la mise en place du patch, l'installation de SCE 2007 se termine enfin.

C'est beau.

[Résolu]Installation SCE 2007 : Erreur SQL Server Reporting

[Résolu]Installation SCE 2007 : Erreur SQL Server Reporting

Qui est en ligne ?