Question:
I have a new USS installation and I moved the USS_mdb database from the SQL Server DBMS instance that hosts the MDB database to another SQL Server DBMS instance.
How can I configure the USS application to use the USS_mdb of the new instance? Specifically, where is the location of the database defined?
Answer:
- Navigate to the installation directory of Unified Self Service.
For example, the default installation directory is "C:\Program Files\CA\Self Service\OSOP".
- Edit "Portal-ext.properties" and find the statement in that file that is similar to the following statement:
jdbc.default.url=jdbc:jtds:sqlserver://SM141DB1:1433/USS_mdb
- Verify the location, or change "//<servername>:<port>/<USS_database_name>" to the correct location.
- If you changed the location, restart the USS services.