Check DB connectivity via command line, using jdbc bundled with the SWS installer.

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.
• 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