Workflow Advanced manual database setup

Article:HOWTO9466  |  Created: 2008-10-22  |  Updated: 2008-10-22  |  Article URL http://www.symantec.com/docs/HOWTO9466
Article Type
How To



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.


Legacy ID



44116


Article URL http://www.symantec.com/docs/HOWTO9466


Terms of use for this information are found in Legal Notices