Workspace Streaming

This document guides to install Symantec Workspace Streaming Server with the already installed DB Instance [OPTION 2] with SQL 2005 Database.

Pre-Requisites:

A machine should be designated as a Database Server with SQL 2005 DB installed. This machine can either be same as the SWS Server or it can be a stand alone server.

SQL 2005 Configurations:

1. Login to Microsoft SQL Server Management Studio as a dbowne...xxxxx
2. Create database name as "appstream" with 500 mb for transaction file and 250 mb for log file in the instance you are going to use. The database should be created with option AUTO FILE GROWTH 50. The database should be created with COLLATION "SQL_Latin1_General_CP1_CI_AS"

   

3. Create a login user name in the Microsoft SQL Server Management studio for e.g "swstest"

   

4. The "login user" should have been granted access to db with "sp_grantdbaccess" and the Login user should have been given create table, create procedure and create view privileges to Appstream database.

   
   Execute the following SQL query to set the permission for the user "swstest"

   Use appstream;
        EXEC sp_grantdbaccess N'swstest', N'swstest'
    GRANT CREATE TABLE, CREATE PROCEDURE, CREATE VIEW TO swstest
   
   

   

SWS Server Installation:

Now start installing SWS server with SQL 2005 DB with the 2nd Option.

NOTE:
If any errors going to appear while installing SWS server with this configuration, please look in the DbJDBCConnectionCheck.log for more information about the error.The log will be located in "%Programfiles%\Symantec\Workspace Streaming\Server\appstreamtmp\.