Adding a CPM Views connection - Microsoft SQL Server

To add a CPM Views connection for a Microsoft SQL Server database:

  1. On the Manage Data Sources page.
  2. Click New and select CPM Views as the connection type.
  3. In the Data Source Name box, specify a name for the data source. Use DecisionViews as the name for the CPM Workstation active views database.
  4. Select ViewDatabase as the category.
  5. Select Microsoft SQL Server.
  6. Specify the user name of the database owner.
  7. Specify the password for the administrator user.
  8. Specify the name of the server computer on which the database software is installed.
  9. Select the database to connect to the data source. If necessary, click Refresh to update the list of available databases.
  10. Click Test Connection.
  11. Click Save.