The following is checklist for the creation process of a Workgroup Database in SQL Server.
- Download the appropriate creation script from the Autodesk website (or from the InfoWorks Workgroup Server installation directory for versions prior to 8.0). Make sure that you have the correct scripts for your application. Either:
- ICM/ICMLive/InfoNet
- WS Pro/IWLive Pro/DemandWatch Pro
- Open the SQL Server creation script, SQL_Create.sql, in a text editor.
- Find the line near the end of the script, which starts:
INSERT INTO global …
- Replace the default database identifier “SQL_INNOVYZEWG00” to a unique value. This will normally be the last argument in the INSERT statement.
- Select “Snapshot isolation” by removing the comment from the last instruction in the script and replacing MyDatabase with the SQL database name (not the InfoWorks Workgroup Server database identifier):
ALTER DATABASE MyDatabase SET ALLOW_SNAPSHOT_ISOLATION ON
The following steps are usually carried out using SQL Server Management Studio:
- Create an empty SQL Server Database with the same name as used in Step 5.
- Run the scripts.
- Check that all instructions ran without errors and that the global table has a single row.
On the machine running the InfoWorks Workgroup Server:
- Create an empty folder in the Data Store directory, using a database name suitable for end users. Ensure that the folder name ends with “.sndb”, so that it is identified as a database folder to the InfoWorks Workgroup Server.
- Create the master.ini file within this folder (see earlier in this document for how to do this).
- Clients should now be able to connect to this database in the usual manner.