Check DB connectivity via command line, using jdbc bundled with the SWS installer.
book
Article ID: 179630
calendar_today
Updated On:
Products
Workspace Streaming (formerly AppStream)
Issue/Introduction
Resolution
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.