Setting up the MSSQL database for Enterprise Server 9
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 Enterprise 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 Enterprise Server.
Step 6. Click OK.
- In the Management Studio, the Tables entry beneath Enterprise shows all tables created by the dbadmin tool.
- If you want to have multiple databases and you already have an Enterprise database installed, do NOT rename the Enterprise database in order to create another one with the name Enterprise. Creating another Enterprise database this way results in errors in the Management Studio. Instead, create a new database with a different name, for example EnterpriseDemo, and rename the DBSELECT option in the config.php file as well. This enables you to easily switch between installed databases.