How can I find the location of the database that is used by Unified Self Service (USS) with CA Service Desk Manager?

Document ID : KB000033585
Last Modified Date : 14/02/2018
Show Technical Document Details

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: 

  1. Navigate to the installation directory of Unified Self Service. 

    For example, the default installation directory is "C:\Program Files\CA\Self Service\OSOP".
     
  2. 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
     
  3.  Verify the location, or change "//<servername>:<port>/<USS_database_name>" to the correct location. 
     
  4. If you changed the location, restart the USS services.