During the installation of Sentinel 3.1.1 on SQL Server 2005 SP3, an error message appears in the install.log:
2009-12-28 11:31:59 INFO  SynUpdateApply.run Executing scripts with XDBM
2009-12-28 11:32:00 ERROR SynUpdateApply.run Execution script error, see associated log files
2009-12-28 11:32:00 INFO  SynUpdateApply.run Updating "component.properties"...
2009-12-28 11:32:00 ERROR SynUpdateApply.run Update operation ended with error.

The solution below describes the procedure that has to be used to perform a successful installation.

Steps to install Sentinel 3.1.1 with database MS SQL Server 2005 SP3 :

1) During installation, choose : "Declare an existing DB" and "create new database model"

(If you choose "Update component model", you will have error during installation "Connexion error")

and "Select : MS SQL Server 2000"

2) Installation will terminated with error. In install.log, the error message below should appear:

2009-12-28 11:31:59 INFO  SynUpdateApply.run Executing scripts with XDBM
2009-12-28 11:32:00 ERROR SynUpdateApply.run Execution script error, see associated log files
2009-12-28 11:32:00 INFO  SynUpdateApply.run Updating "component.properties"...
2009-12-28 11:32:00 ERROR SynUpdateApply.run Update operation ended with error.

3) Install the latest Service pack on Sentinel (SP13 or more recent) : installation will be terminated with error

4) Update the JDBC driver in XDBM :

       - rename in folder ''<SYNCHRONY>\Tools\XDBM\lib\ext'' the file ''mssqlserver.jar'' by ''mssqlserver_old.jar''
       - copy <SYNCHRONY>\Sentinel_V3.1.1\lib\mssqlserver\sqljdbc-1.1.1501.101.jar  into <SYNCHRONY>\Tools\XDBM\lib\ext
       - rename this file in ''mssqlserver.jar''
       - modify following lines in <SYNCHRONY>\Tools\XDBM\settings\Sentinel_3.1_x.properties :

#Axway Database Manager properties file for Synchrony Sentinel_3.1_x
#<installation data and time>
<host name>\:<SID>\:<schema>.type=sqlserver
componentDirectory=C\:\\Axway\\Synchrony_V4.0mssql
Sentinel_V3.1.1
<host name>\:<SID>\:<schema>.url=jdbc\:microsoft\:sqlserver\://<host name>\:<port>;DatabaseName\=<SID>;SelectMethod\=cursor
dependingOn=
<host name>\:<SID>\:<schema>.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver

by :
#Axway Database Manager properties file for Synchrony Sentinel_3.1_x
#<installation date and time>
<host name>\:<SID>\:<schema>.type=sqlserver
componentDirectory=C\:\\Axway\\Synchrony_V4.0mssql
Sentinel_V3.1.1
<host name>\:<SID>\:<schema>.url=jdbc\:sqlserver\://<host name>\:<port>;DatabaseName\=<SID>;SelectMethod\=cursor
dependingOn=
<host name>\:<SID>\:<schema>.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

       - launch XDBM manually ( sh xdbmcmd.sh Sentinel_3.1_x <HOST>:<SID>:<USER> <PASSWD> )

5) Check if tables have been created in Sentinel instance (XDBM_LOG, TrackingObject, TimerQueue, ...)

6) check that Sentinel starts properly