Check DB connectivity via command line, using jdbc bundled with the SWS installer.
| Article:HOWTO21533 | | | Created: 2010-01-21 | | | Updated: 2010-01-21 | | | Article URL http://www.symantec.com/docs/HOWTO21533 |
Question
How can a user check DB connectivity via command line using jdbc bundled with the SWS installer?
Answer
Please execute the following command line on the machine where back end will be installed:
"C:\install\disk16.1SP2\Server\program files\AppStream\awe\common\jdk1.6.0_03\bin\java.exe" -Dappstream.home="C:\Program Files\Symantec\Endpoint Virtualization\Workspace Streaming\Server\appstreamtmp" -cp "C:\install\disk16.1SP2\Server\program files\AppStream\awe\agent\lib\awe_legacy.jar;C:\install\disk16.1SP2\Server\program files\AppStream\awe\agent\lib\commons-codec-1.3.jar;C:\install\disk16.1SP2\Server\program files\AppStream\awe\agent\lib\log4j.jar;C:\install\disk16.1SP2\Server\program files\AppStream\awe\agent\lib\jdom.jar;C:\install\disk16.1SP2\Server\program files\AppStream\awe\agent\lib\jtds-1.2.2.jar" com.appstream.cm.installation.DbJDBCConnectionCheck mssql2005 <server IP/HOST> 1433 "sa" "sa_account_password" <instance_name> master
Where:
- server IP/HOST is the hostname or IP of the database server.
- 1433 the port that the database listens to.
- sa is the default database user account.
- sa_account_password is the password for the sa account.
- instance_name is the database instance on which the appstream database is to be installed and configured.
- master is the system database.
For example:
"C:\install\disk16.1SP2\Server\program files\AppStream\awe\common\jdk1.6.0_03\bin\java.exe" -Dappstream.home="C:\Program Files\Symantec\Endpoint Virtualization\Workspace Streaming\Server\appstreamtmp" -cp "C:\install\disk16.1SP2\Server\program files\AppStream\awe\agent\lib\awe_legacy.jar;C:\install\disk16.1SP2\Server\program files\AppStream\awe\agent\lib\commons-codec-1.3.jar;C:\install\disk16.1SP2\Server\program files\AppStream\awe\agent\lib\log4j.jar;C:\install\disk16.1SP2\Server\program files\AppStream\awe\agent\lib\jdom.jar;C:\install\disk16.1SP2\Server\program files\AppStream\awe\agent\lib\jtds-1.2.2.jar" com.appstream.cm.installation.DbJDBCConnectionCheck mssql2005 192.168.1.120 1433 "sa" "sa" appdb master
Legacy ID
51076
Article URL http://www.symantec.com/docs/HOWTO21533
Terms of use for this information are found in Legal Notices
Thank you.