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