(imported comment written by tshambrey)
I am still having problems installing remote control that connect to my SQL server 2005 here are the things that I’ve done/checked
-
create sql database from SQL server manager studio Express TRCDB (also tried install without manually creating dbdata)
-
set .sql database is in mix mode authentication
-
sa is the owner of the database
-
download and installed the jdbc driver (location c:\sqljdbc_30\enu\sqljdbc.jar)
-
create empty folder c:\sqldata\ trcdb
-
changed WEBSITE Port from 80 to 9080 and 442 to 9443 (tried both ways)
-
create task (see below)
-
see error from task run
fixlet tast
delete __createfile
createfile until __ENDCREATE
INSTALLER_UI=SILENT
AdvancedWeb=NO
DATABASE_CHOICE=MSSQL_2005
DB2_DATABASE_CREATE_ON=
DB2_DATABASE_NAME=TRCDB
DB2_DROP_DATABASE=NO
DB2_JDBC_DRIVERS_PATH=
DB2_LIB_DIRECTORY=
DB2_LOCAL=NO
DB2_PASSWORD=db2pass
DB2_PORT=50000
DB2_PROFILE_PATH=
DB2_SERVER_ADDRESS=127.0.0.1
DB2_USERID=db2admin
DERBY_DB_NAME=TRCDB
FIPS_ON=NO
MSSQL_DATABASE_CREATE_DIR=C:\sqldata\trcdb\rc
MSSQL_DATABASE_NAME=TRCDB
MSSQL_DROP_DATABASE=YES
MSSQL_JDBC_DRIVER=C:\sqljdbc_3.0\enu\sqljdbc4.jar
MSSQL_LOCAL=YES
MSSQL_PASSWORD=12deffd@ts
MSSQL_PORT=1433
MSSQL_SERVER_ADDRESS=127.0.0.1
MSSQL_USERID=sa
OperatingSystem=Windows
ORA_DATABASE_NAME=TRCDB
ORA_JDBC_DRIVER=
ORA_PASSWORD=sys
ORA_PORT=1521
ORA_SERVER_ADDRESS=127.0.0.1
ORA_USERID=sys
SP800131A_ON=NO
USER_INSTALL_DIR=C:\Program Files\IBM\Tivoli\TRC\server
WAS_ADMIN_PORT=
WAS_ADMIN_SSL_PORT=
WAS_IPC_CONNECTOR_PORT=
WAS_RMI_PORT=
WAS_SOAP_PORT=
WEBSITE_ADDRESS=localhost
WEBSITE_ADMIN_EMAIL=admin@sdfsfd.com
WEBSITE_HTTPPORT=9080
WEBSITE_HTTPSPORT=9443
WEBSITE_SUBDIR=trc
WEBSITE_TARGET_DEFAULT_HTTP_OR_HTTPS=1
WizDownload_Location=
__ENDCREATE
copy __createfile __Download\TRC.properties
prefetch TRC_win.bfa sha1:0cac9a488297602a492c8cdfc941bc3960985dec size:428090371
http://software.bigfix.com/download/TRC/910_0303/TRC_win_0303.bfa
sha256:1282beebdb6f743f4c0c6bfe6d019fdf7ca916ff2ff69dcd751e6814e12a5c95
dos mkdir C:\sqldata\trcdb\rc
extract TRC_win.bfa
waithidden __Download\TRC.exe
continue if {exit code of action = 0}
dos rmdir C:\sqldata\trcdb\rc
delete __createfile
Error from task
The action failed.
This action has been applied 1 time and will not be applied again.
Status Failed
Start Time 8/22/2014 9:39:29 PM
End Time 8/22/2014 9:40:12 PM
Exit Code -1
Action Script Execution Detail
Completed delete __createfile
Completed createfile until __ENDCREATE
Completed INSTALLER_UI=SILENT
Completed AdvancedWeb=NO
Completed DATABASE_CHOICE=MSSQL_2005
Completed DB2_DATABASE_CREATE_ON=
Completed DB2_DATABASE_NAME=TRCDB
Completed DB2_DROP_DATABASE=NO
Completed DB2_JDBC_DRIVERS_PATH=
Completed DB2_LIB_DIRECTORY=
Completed DB2_LOCAL=NO
Completed DB2_PASSWORD=db2pass
Completed DB2_PORT=50000
Completed DB2_PROFILE_PATH=
Completed DB2_SERVER_ADDRESS=127.0.0.1
Completed DB2_USERID=db2admin
Completed DERBY_DB_NAME=TRCDB
Completed FIPS_ON=NO
Completed MSSQL_DATABASE_CREATE_DIR=C:\sqldata\trcdb\rc
Completed MSSQL_DATABASE_NAME=TRCDB
Completed MSSQL_DROP_DATABASE=YES
Completed MSSQL_JDBC_DRIVER=C:\sqljdbc_3.0\enu\sqljdbc4.jar
Completed MSSQL_LOCAL=YES
Completed MSSQL_PASSWORD=12deffd@ts
Completed MSSQL_PORT=1433
Completed MSSQL_SERVER_ADDRESS=127.0.0.1
Completed MSSQL_USERID=sa
Completed OperatingSystem=Windows
Completed ORA_DATABASE_NAME=TRCDB
Completed ORA_JDBC_DRIVER=
Completed ORA_PASSWORD=sys
Completed ORA_PORT=1521
Completed ORA_SERVER_ADDRESS=127.0.0.1
Completed ORA_USERID=sys
Completed SP800131A_ON=NO
Completed USER_INSTALL_DIR=C:\Program Files\IBM\Tivoli\TRC\server
Completed WAS_ADMIN_PORT=
Completed WAS_ADMIN_SSL_PORT=
Completed WAS_IPC_CONNECTOR_PORT=
Completed WAS_RMI_PORT=
Completed WAS_SOAP_PORT=
Completed WEBSITE_ADDRESS=localhost
Completed WEBSITE_ADMIN_EMAIL=admin@sdfsfd.com
Completed WEBSITE_HTTPPORT=9080
Completed WEBSITE_HTTPSPORT=9443
Completed WEBSITE_SUBDIR=trc
Completed WEBSITE_TARGET_DEFAULT_HTTP_OR_HTTPS=1
Completed WizDownload_Location=
Completed __ENDCREATE
Completed copy __createfile __Download\TRC.properties
Completed prefetch TRC_win.bfa sha1:0cac9a488297602a492c8cdfc941bc3960985dec size:428090371
http://software.bigfix.com/download/TRC/910_0303/TRC_win_0303.bfa
sha256:1282beebdb6f743f4c0c6bfe6d019fdf7ca916ff2ff69dcd751e6814e12a5c95
Completed dos mkdir C:\sqldata\trcdb\rc
Completed extract TRC_win.bfa
Completed waithidden __Download\TRC.exe
Failed continue if {exit code of action = 0}
dos rmdir C:\sqldata\trcdb\rc
delete __createfile