# Configure the Adaptiva Database

The Adaptiva database will need to be configured to support Web WakeUp functionality.

## Status Table Creation

A table must be created in the Adaptiva database to support Web WakeUp functionality.

1. Get the **Wake\Control\StatusTable.sql** file from the Web WakeUp server.
2. Connect to the SQL server which hosts the Adaptiva database.
3. Open Microsoft SQL Management Studio and connect to the appropriate instance.
4. Navigate to **`<SQLServer>` > Databases** and select the **Adaptiva** database.
5. Double-click **StatusTable.sql** to open the SQL query editor.
   * If the Adaptiva database is named something other than *adaptiva* the Use statement in the query will need to be modified to reflect the name of the Adaptiva database. Ex: USE \[MyDatabaseName]
6. Click **Execute**.

   ![](https://226687595-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FopDQFA2ESgR7Cn1Z9WcH%2Fuploads%2Fgit-blob-14accdd6e46f7831be5e4a8aca1c1d2d78804b10%2Fexecute.png?alt=media)
7. To verify, expand Adaptiva / Tables and verify that the **dbo.GP\_WOL** table exists.

## SQL Permissions

The Web WakeUp domain-based service account will need read access to both the Adaptiva and the Configuration Manager databases. The following section describes the process.

1. In SQL Management Studio, Navigate to **`<SQLServer>` > Security**.
2. Right-click **Logins** and select **New Login…**.
3. Enter the **Login name** of the Web WakeUp Service account.

   ![](https://226687595-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FopDQFA2ESgR7Cn1Z9WcH%2Fuploads%2Fgit-blob-608cc401e5c8278eafcd9dc6abd7ca04065b0d95%2Flogin-name.png?alt=media)
4. Select **User Mapping** from the left side navigation.
5. Check the box next to the name of the ConfigMgr database and the Adaptiva database.
6. Check `db_datareader` under **Database role membership**.

   ![](https://226687595-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FopDQFA2ESgR7Cn1Z9WcH%2Fuploads%2Fgit-blob-a87a2a96c8a79959fd5e49623773689cc0a0c792%2Flogin.png?alt=media)
7. Click **OK**.