Before you begin:

Database connection information is found in the TWBS_WS_OCMP table in the Versago Common database. Use the following query to list the existing connections.

SELECT * FROM TWBS_WS_OCMP

The key fields needed to make this change are:

• ID
• ServerName
• DBName

• Determine the ID of the connection to be changed.
• Note the existing ServerName and DBName values.
• Be sure you have the new value(s) for ServerName and/or DBName.
• Use the query shown below to update the record.

Update the Target Server

UPDATE TWBS_WS_OCMP
SET ServerName = <NewName>
WHERE ID = <AppropriateID>

Update the Target Database

UPDATE TWBS_WS_OCMP
SET DBName= <NewName>
WHERE ID = <AppropriateID>

Update Both the Target Server and Database

UPDATE TWBS_WS_OCMP
SET ServerName = <NewName>, DBName= <NewName>
WHERE ID = <AppropriateID>

• Open the Versago Admin page.
• Open the Settings > Databases page
• Confirm that the values are displayed correctly.
• Execute a report that uses the changed connection and confirm that the information returned is correct.