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

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

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.

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component: