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

Article Id: 33585
Status: Published
Updated On: 14-02-2018 08:19
Legacy Id: TEC1184705
Products:
SUPPORT AUTOMATION- SERVER , CA Service Desk Manager - Unified Self Service , KNOWLEDGE TOOLS , 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: