Creating an MS SQL Server Database
Creating the MS SQL Server Database via the MS SQL Enterprise Manager

 Tip:

This guide explains how to create an MS SQL server database for Chromeleon. For general instructions about how to install MS SQL Server and create a database, refer to the Microsoft MS SQL Server documentation.

• Create a Database through the MS SQL 'Enterprise Name,' using the default settings.

• Enter a meaningful name for the new database. (The name will be used for the ODBC connection).

• Assign at least two users to the database - an administrator and a normal user - using the MS SQL login (create specific users for the database).

Administrator

The administrator account is used to set up and manage the Chromeleon database, so full privileges should be granted to this account. Essential privileges are those for creating tables and views; all the tables are created when the administrator connects to the database via Chromeleon for the first time. (A typical name for the administrator would be CMADMIN.)

Normal User

This is the normal user account that connects to the database via Chromeleon during routine operation. This account must have the following two privileges for the Chromeleon database:

• db_datareader

• db_datawriter

More privileges are not necessary in order to access the data through Chromeleon. (A typical user name would be CmUser or simply CM.)

 Tip:

The MS SQL login is required to impersonate the user on the database. Once the connection is made, any user can log on to Chromeleon, subject to the access rights and privileges set in the Chromeleon security system.

For more information about how to create MS SQL server data sources, refer to How to: Working with Files, Databases, and Networks:

 Creating the Folder Structure for Data

 Connecting the MS SQL Server Database to Chromeleon

Also, refer to  Notes on Installing Datasources on MS SQL Databases.