Workflow Advanced manual database setup

Products

• Workflow Solution

Issue/Introduction

 

Resolution

Question
How do I setup the Altiris Workflow Solution Advanced 6.5 database manually if the database setup fails?

Answer

1. Create new database called "Ensemble" on the MSSQL server
   Can be done via sql query "CREATE DATABASE [Ensemble] COLLATE SQL_Latin1_General_CP1_CI_AS"
    
2. Create new database user and grant it access to newly created database
      Can be done via sql queries:
      ==== start of sql query ====
      sp_addlogin 'EnsembleLogin', 'ensPa$Sw0rD', 'Ensemble'
      GO
      use [Ensemble]
      GO
      sp_grantdbaccess [EnsembleLogin]
      GO
      sp_addrolemember 'db_owner', [EnsembleLogin]
      ==== end of sql query ====
    
3. Open and execute in [Ensemble] database the following scripts from C:\Program Files\Altiris\Workflow Designer\Ensemble\SQL folder:
   tables.sql,  data.sql  and AdminUser.sql in exact order.
    
4. Edit the C:\Program Files\Altiris\Workflow Designer\Ensemble\web.config file
   
5. Find '<add key="ConnectionString"' tag (under <configuration>\<DataAccessConfiguration>\<ConnectionInstance> xml hierarchy)
   
6. Change the "value=" attribute to be "Data Source=(local); Initial Catalog=Ensemble; User ID=EnsembleLogin; Password=ensPa$Sw0rD".
   
      **Note:  If you has MSSQL Express version, change "Data Source=(local);" to be "Data Source=(local)\SQLEXPRESS;". If you sql server is
      installed on other machine, change (local) to the SQL server IP Address.

Note: It is likely that a restart of IIS and/or the LogicBase Server Extensions will be required after this process to get the connection working properly.