Setting up the MSSQL database for Studio Server

Info: Performing the steps described in this article requires direct server access. Depending upon how your system is hosted and the level of access you have to that system, coordination may be required with your Partner or WoodWing Support team. For a full overview of the steps that need to be done by WoodWing and how to request them, see WoodWing Cloud - Change management.

Note: In the following steps, MSSQL 2008 is used. Please be aware that MSSQL 2012 might be slightly different.

Step 1. Start Microsoft SQL Server Management Studio.

Step 2. In the Object Explorer on the left side of the screen, do the following:

Step 2a. Unfold the machine name entry (the root node of the tree). Make sure that the machine name matches the DBSERVER option in the configserver.php file.

Step 2b. Unfold the Databases entry, right-click it and choose New Database.

The New Database dialog box appears.

Step 3. Make sure that the General entry is selected.

Step 4. Enter Studio Server as the database name.

Note: This can be any name, as long as it matches the DBSELECT option in the config.php file.

Step 5. Select the Options entry.

Step 6. For collation, choose the option Latin1_General_CI_AI.

Important: You must choose the Latin1_General_CI_AI option regardless of your language, country or region. Other options are NOT supported by Studio Server.

Step 6. Click OK.

Remarks

• In the Management Studio, the Tables entry below Studio Server shows all tables created by the dbadmin tool.
• If you want to have multiple databases and you already have an Studio Server database installed, do NOT rename the Studio Server database in order to create another one with the name Studio Server. Creating another Studio Server database this way results in errors in the Management Studio. Instead, create a new database with a different name, for example Studio Server Demo, and rename the DBSELECT option in the config.php file as well. This enables you to easily switch between installed databases.