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.

   
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.

   
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.

   
7. Click OK.