Documentation Center

Creating a Microsoft SQL Server State Store database manually

Only if you have a pressing reason to do so, create your State Store database for SQL Server, Azure or AWS manually by running the database scripts provided.

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. Open the script called DP_STATE_CREATE.sql for editing.
  5. Replace the dummy name for the database, [StateStoreDbName] with the name you want to give this database, for example, State_Store.
  6. Create the database by running the script called DP_STATE_CREATE.sql as a database administrator user (sa).
  7. Edit all scripts mentioned below as well, to reflect the new name.
  8. Run the following scripts:
    • DP_STATE_TABLES.sql
    • DP_STATE_CONSTRAINTS.sql
    • DP_STATE_INDEXES.sql
    • DP_STATE_SET_VERSION.sql (located in Database\Scripts\MSSQL\Shared\85\.
    • Either DP_STATE_CREATE_LOGIN_AWS.sql if you are installing a database in AWS, or DP_STATE_CREATE_LOGIN.sql otherwise.
    • DP_STATE_ALTER_LOGIN.sql (only if you are installing an on-premise Microsoft SQL Server database, so no AWS or Azure database). Run as a database administrator user (sa).
    • DP_STATE_CREATE_USER.sql

Results

You have created the State Store.

What to do next

When installing the combined Content Deployer Role, Content Deployer endpoint Role or Content Deployer worker Role, you configure the State Store in the Storage Layer configuration file.