Environment
Sentinel Server 5.1.2
Windows 2003
MS SQL 2000
MS SQL 2005
Windows 2003
MS SQL 2000
MS SQL 2005
Situation
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]Connection-open (Connect()
Attempting to run patchdb.bat or setup.exe for the 5.1.2 upgrade of the database.
[DBNETLIB]Connection-open (Connect()
Attempting to run patchdb.bat or setup.exe for the 5.1.2 upgrade of the database.
Resolution
The database port number was a non-default port of 2005. If you are
using a non-standard port number you must manually configure the
.bat file and change the appropriate authentication type line for
SQL_Auth or Windows_Auth to include the port number you are using.
As you can see from the example below, there is a parameter "-port"
this needs to be changed to reflect the port number for your
database.
Patch_Sql_Auth
java -Desecurity.log.console=true -cp %LOCAL_CLASSPATH% esecurity.db.install.PatchDB -db mssql -host %DB_HOST% -port 1433 -dbname %DB% -to %TARGET_VERSION% -os windows -installdir"%INSTALL_DIR%" -logdir "%LOG_DIR%" -password %ESECDBA_PASS%
GOTO End_Patch
:Patch_Win_Auth
java -Desecurity.log.console=true -cp %LOCAL_CLASSPATH% esecurity.db.install.PatchDB -db mssql -host %DB_HOST% -port 1433 -dbname %DB% -to %TARGET_VERSION% -os windows -installdir"%INSTALL_DIR%" -logdir "%LOG_DIR%"
1. Copy the patchdb.bat to another location
2. Edit the patchdb.bat and replace -port 1433 to -port
3. Save the patchdb.bat and re run from the command line.
This has since been fixed in version 5.1.3 for Sentinel.
Patch_Sql_Auth
java -Desecurity.log.console=true -cp %LOCAL_CLASSPATH% esecurity.db.install.PatchDB -db mssql -host %DB_HOST% -port 1433 -dbname %DB% -to %TARGET_VERSION% -os windows -installdir"%INSTALL_DIR%" -logdir "%LOG_DIR%" -password %ESECDBA_PASS%
GOTO End_Patch
:Patch_Win_Auth
java -Desecurity.log.console=true -cp %LOCAL_CLASSPATH% esecurity.db.install.PatchDB -db mssql -host %DB_HOST% -port 1433 -dbname %DB% -to %TARGET_VERSION% -os windows -installdir"%INSTALL_DIR%" -logdir "%LOG_DIR%"
1. Copy the patchdb.bat to another location
2. Edit the patchdb.bat and replace -port 1433 to -port
3. Save the patchdb.bat and re run from the command line.
This has since been fixed in version 5.1.3 for Sentinel.