QuestionHow do I setup the Altiris Workflow Solution Advanced 6.5 database manually if the database setup fails?
Answer
- 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"
- 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 ====
- 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.
- Edit the C:\Program Files\Altiris\Workflow Designer\Ensemble\web.config file
- Find '<add key="ConnectionString"' tag (under <configuration>\<DataAccessConfiguration>\<ConnectionInstance> xml hierarchy)
- 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.