).The scripts needed to create (or upgrade) a SQL Server database are included with the CM4D Installation. Browse to the Database Scripts\SQLServer folder in your CM4D install directory.
1. Right-click on Databases in the tree and select New Database from the context menu.
a. In the New Database dialog:
i. Enter the Database name (e.g., CM4D).
ii. Set the Initial Size of the Rows Data file to 500 (MB).
iii. Set the Initial Size of the Log file to 50 (MB).
b. Click OK.
2. Next, you will need to run the Create scripts for the CM4D database.
a. Click
the open file button ().
b. Browse to the scripts for the Schema version that corresponds to the version of CM4D that you are running.
c. Select Tables.sql.
d. Click Open.
3. In the use line of the script:
a. Delete the two hypens (--) at the beginning of the line.
b. Change [Your CM4D DB] to the name of the database you are running the scripts on.
c. As you type in the name, a list of databases will appear, allowing you to select your database name.
4. Once you have the correct database name entered between the brackets, select the Execute button.
5. Check the Messages section for any errors.
a. If the scripts execute successfully, go to the next step.
b. If the scripts return errors, investigate the issue(s).
6. Repeat the previous steps for the Procedures.sql, Indexes.sql, and Grant.sql scripts.
7. Once the CM4D database scripts have been run successfully, continue on to the next section to create the CM4D user login (if using SQL Authentication).
See also, Create a SQL Authentication User.