Documentation Center

Creating a Microsoft SQL Server Experience Manager database manually

Create your Microsoft SQL Server Experience Manager database manually by running database scripts that create the database and its tables.

Procedure

  1. Close all connections to your Microsoft SQL Server database server.
  2. Access your SDL Web installation media.
  3. Navigate to the folder Database\Scripts\MSSQL\Create\.
  4. Create the database by running the script called CD_BROKER_CREATE.sql as a database administrator user (sa). By default, the script creates a database called cd_broker_db. To change this, edit the script to use a different name.
  5. If you changed the name of the database that the script created, edit the scripts listed below, changing the name cd_broker_db to your chosen name throughout.
  6. Run these scripts as a database administrator user (sa):
    • CD_BROKER_TABLES.sql
    • CD_BROKER_CONSTRAINTS.sql
    • CD_BROKER_INDEXES.sql
  7. Navigate to the folder Database\Scripts\MSSQL\Shared\85\ and run the following script as a database administrator user (sa), again changing the database name if needed:
    • GENERAL_SET_VERSION.sql

Results

You have created the Experience Manager database.

What to do next

When installing the Experience Manager Server Role, you configure the Experience Manager database in the Storage Layer configuration file.