Documentation Center

Creating a Microsoft SQL Server Discovery Service database manually

Create your Microsoft SQL Server Discovery Service 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