Hi,I have problems with failed installation of SCE 2007 SP1 onto Windows Server 2008 Standard x86 SP2. Database used is SQL Server 2005 Express with AS SP3. Reporting Services were installed using the KB 938245.Installation fails with error "Error 26203.Failed to connect to SQL database. (-2147467259 OperationsManagerDW )".I've chosen to install SCE files to E:\Program Files\System Center Essentials 2007\ and to store database files to E:\SCE\Database\. Both paths were selected using the setup GUI. In fact, the setup will create .mdf file for DW on the wrong path: E:\SCE\DatabaseOperationsManagerDW.mdf. But it is able to connect to the database and suddenly it is not.MSI (s) (EC:64) [15:23:40:123]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIF930.tmp, Entrypoint: CreateDatabaseCreateDatabase: Custom Action Data. MOMXDBGLASGOW\SQLEXPRESSOperationsManagerDW01000E:\SCE\DatabaseE:\SCE\DatabaseCreateDatabase: Succesfully connected to 'master' database on server. GLASGOW\SQLEXPRESSCheckDatabaseExists: Succesfully connected to 'master' database on server. GLASGOW\SQLEXPRESSCheckDatabaseExists: Succesfully retrived database list from 'master' database. CreateDatabase: Creating database. OperationsManagerDWCreateDatabase: Create database query. CREATE DATABASE ON PRIMARY(NAME=MOM_DATA,FILENAME='E:\SCE\DatabaseOperationsManagerDW.mdf',SIZE=1000MB,MAXSIZE=UNLIMITED,FILEGROWTH=10%) LOG ON(NAME=MOM_LOG, FILENAME='E:\SCE\DatabaseOperationsManagerDW.ldf',SIZE=500MB,MAXSIZE=UNLIMITED,FILEGROWTH=10%) COLLATE SQL_Latin1_General_CP1_CI_ASMSI (s) (EC:E4) [15:23:48:975]: Executing op: ActionStart(Name=_ExecuteSqlScripts,Description=Creating database objects,)CreateDatabase: Succesfully created database. OperationsManagerDWMSI (s) (EC:E4) [15:23:49:064]: Executing op: CustomActionSchedule(Action=_ExecuteSqlScripts,ActionType=17409,Source=BinaryData,Target=ExecuteSqlScripts,CustomActionData=1MOMXDBGLASGOW\SQLEXPRESSOperationsManagerDWMOMBuildAllSQLE:\Program Files\System Center Essentials 2007\Reporting\Database\Datawarehouse.Initial.Setup.sqlMOMLocaleSQLInstallE:\Program Files\System Center Essentials 2007\Reporting\Database\build_momv3_dw_localization.sql)MSI (s) (EC:BC) [15:23:49:072]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI1C1B.tmp, Entrypoint: ExecuteSqlScriptsExecuteSqlScripts: Custom Action Data. 1MOMXDBGLASGOW\SQLEXPRESSOperationsManagerDWMOMBuildAllSQLE:\Program Files\System Center Essentials 2007\Reporting\Database\Datawarehouse.Initial.Setup.sqlMOMLocaleSQLInstallE:\Program Files\System Center Essentials 2007\Reporting\Database\build_momv3_dw_localization.sqlExecuteSqlScripts: Database Server Instance. GLASGOW\SQLEXPRESSCheckDatabaseExists: Succesfully connected to 'master' database on server. GLASGOW\SQLEXPRESSCheckDatabaseExists: Succesfully retrived database list from 'master' database. CheckDatabaseExists: Database exists. OperationsManagerDWExecuteSqlScripts: Succesfully connected to database. OperationsManagerDWExecuteSqlScripts: Executing SQL script. E:\Program Files\System Center Essentials 2007\Reporting\Database\Datawarehouse.Initial.Setup.sqlExecuteSqlScriptFileFromMsi: CreateFile successfully opened file. E:\Program Files\System Center Essentials 2007\Reporting\Database\Datawarehouse.Initial.Setup.sqlExecuteSqlScripts: Executing SQL script. E:\Program Files\System Center Essentials 2007\Reporting\Database\build_momv3_dw_localization.sqlMSI (s) (EC:E4) [15:24:23:289]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings,)ExecuteSqlScriptFileFromMsi: CreateFile successfully opened file. E:\Program Files\System Center Essentials 2007\Reporting\Database\build_momv3_dw_localization.sqlMSI (s) (EC:E4) [15:24:23:292]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=17409,Source=BinaryData,Target=ExecuteSqlStrings,CustomActionData=DB_MOMDB.9B663534_CD9B_41CC_9D93_4E84D3C5E165€GLASGOW\SQLEXPRESS€€OperationsManagerDW€-2147483648€1€€€Delete_DWDBVersion.9B663534_CD9B_41CC_9D93_4E84D3C5E165€5€DELETE ManagementGroupProductVersion WHERE ManagementGroupGuid='71aa8fce-8809-9287-cc42-1ea58eea4bc4')MSI (s) (EC:50) [15:24:23:298]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIA1D6.tmp, Entrypoint: ExecuteSqlStringsExecuteSqlStrings: Error 0x80004005: failed to connect to database: 'OperationsManagerDW'MSI (s) (EC:D8) [15:32:49:969]: I/O on thread 3588 could not be cancelled. Error: 1168MSI (s) (EC:D8) [15:32:49:977]: I/O on thread 5728 could not be cancelled. Error: 1168MSI (s) (EC:D8) [15:32:49:977]: I/O on thread 4192 could not be cancelled. Error: 1168MSI (s) (EC:D8) [15:32:49:977]: I/O on thread 4580 could not be cancelled. Error: 1168MSI (s) (EC:D8) [15:32:50:012]: I/O on thread 4380 could not be cancelled. Error: 1168MSI (s) (EC:D8) [15:32:50:013]: I/O on thread 4124 could not be cancelled. Error: 1168MSI (s) (EC:D8) [15:32:50:013]: I/O on thread 1360 could not be cancelled. Error: 1168MSI (s) (EC:D8) [15:32:50:013]: I/O on thread 3924 could not be cancelled. Error: 1168MSI (s) (EC!20) [15:32:50:019]: Product: System Center Operations Manager 2007 Reporting Server -- Error 26203.Failed to connect to SQL database. (-2147467259 OperationsManagerDW ) Error 26203.Failed to connect to SQL database. (-2147467259 OperationsManagerDW )MSI (s) (EC:E4) [15:32:50:114]: User policy value 'DisableRollback' is 0MSI (s) (EC:E4) [15:32:50:114]: Machine policy value 'DisableRollback' is 0Action ended 15:32:50: InstallFinalize. Return value 2.I will send the full log file to scedata@microsoft.comHow can I resolve this error? And why is the setup creating databases on wrong path?Thanks,regards Jozef.-- MCPD Web Applications

Hi Jozef, Could you please try the following steps on install SCE 2007 SP1 on your Windows Server 2008: 1. Configure the Server * Disable IPv6 * Change computer name and join to domain * Disable Windows Firewall 2. Install the Prerequisites * ServerManagerCmd -install NET-Framework-Core * ServerManagerCmd -install Remote-Assistance * ServerManagerCmd -install GPM 3. Install SQL Server 2005 Express SP2 with Advanced Services (As you have installed SQL 2005 express AS with SP3, you can skip this step) * Download and run SQLEXPR_ADV.EXE * During feature selection be sure to highlight Reporting Services and select Enter Feature will be installed on local hard drive. You must also install Management Studio Express. 4. Configure Reporting Services * Start > Run > Inetmgr * Expand [Server Name] > Sites > Default Web Site * Highlight ReportServer$SQLExpress * Double-click Handler Mappings * Click Edit Feature Permissions * Enable Script and click OK (do not enable Execute) * Close Internet Information Services (IIS) Manager 5. Install System Center Essentials with SP1