CSE Installation and Configuration › Prerequisites for CSE Configuration › Configuring Databases › Create Microsoft SQL Server CSE Database

Create Microsoft SQL Server CSE Database

Follow these steps:

1. Start the SQL Server Management Studio.
2. Right-click the SQL Server folder, the highest node in the Object Explorer window, and click Properties to open the properties dialog.
3. In the Server Properties dialog, select the Security tab.
4. In the Security group, click the option button SQL Server and Windows Authentication mode, and click OK.
5. Expand the Databases and System Databases folders to see databases that are currently defined.
6. Right-click the Databases folder and click New Databases in the pop-up menu.
7. In the Database Properties window, complete these fields:
   • Database Name—DBCSE
   • Owner—<default>
   • Use Full Text Indexing—Off
   • Database Files
     • Specify Initial Size of 500 MB for Encyclopedia and 10 MB for Coordination, and your preferred file growth and path properties for the data file.
     • Specify Initial Size of 20 MB for Encyclopedia and 1 MB for Coordination, and your preferred file growth and path properties for the log file.
     • The paths must exist before you create the database.
8. Click OK to create the database.
9. To open the ODBC client, use one of the following steps:
   • On a 32-bit Windows system, open the Control Panel, open Administrative Tools, and double-click Data Sources (ODBC).
   • On a 64-bit Windows system, perform one of the following options:
     • Use the 32-bit version DSN by installing the 32-bit version osql.exe program used by the 32-bit version DSN
     1. Install the 32-bit version of the Microsoft SQL Server Management Studio/ tools to provide the 32-bit version of osql.exe that is needed by the 32-bit DSN during the CSE Configuration step.
     2. Using %systemroot%\syswow64\odbcsd32.exe, define the 32-bit version DSN.
     • Use the 64-bit version DSN by creating the 64-bit version DSN which can be used by the 64-bit version osql.exe program installed by the default
   1. Using %systemroot%\syswow64\odbcsd32.exe, define the 32-bit version DSN that is needed by the CSE runtime itself, being 32- bit software.
   2. Using %systemroot%\system32\odbcsd32.exe, define the 64-bit version DSN.

      Note: The CSE runtime itself, being a 32-bit software, always uses the 32-bit DSN and therefore the 64-bit DSN can be removed after the CSE Configuration step has been successfully completed.

   The ODBC Data Source Administrator panel opens.

10. Select the System DSN tab and click Add.

    The Create New Data Source panel opens.

11. Select SQL Server and click Finish.
12. In the next dialog, type the database name in the Name field, Description, Which SQL Server (local), and click Next.
13. Click With SQL Server authentication.
14. Check Connect to SQL Server to obtain.
15. Complete the database login ID and password, and click Next.
16. Check the Change default database to: box.
17. Click the drop-down, select the database that you created in these steps, and click Next.

    Important! Perform translation for character data must be unchecked. CSE handles its own character translation. Allowing SQL Server to translate would result in corrupted models.

18. Click Finish to create the database and finish ODBC access preparation for the database.