APM 12.6 CASM installation fails while installing on SQL server named instance and dynamic ports

book

Article ID: 49565

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Solution:

The APM 12.6 installation is by default going to use the port 1433.

In SQL server, the default instance has a listener which listens on the fixed port which is TCP port 1433.

However for the named instance, the port on which the SQL server listens is random and is dynamically selected when the named instance of the SQL server starts. This is the default behavior when the ports are not defined for the named instance manually.

When installing APM 12.6 and using SQL Server named instances with dynamic ports, the following steps must be followed to resolve the CASM installation problem, follow the below steps.

  1. Obtain the current running port from the database server thru the SQL server configuration manager.

    1. Start->Programs-> SQL Server (version)->Configuration Tools-> Configuration Manager or

      Click Start >> Run
      For SQL Server 2005 Type "SQLServerManager.msc" and click OK
      For SQL Server 2008 Type "SQLServerManager10.msc" and click OK

    2. In the Configuration Manager screen, expand the SQL Native Client Configuration

    3. Click on Client Protocols

    4. In the list of Client Protocols, click on TCP/IP

    5. This will list the dynamic port the named instance is currently running on

  2. Open the \Program Files\CA\ITAM\InstallConfig\AlleghenyInstallFiles\CASM\setup\installer.properties file and the C:\WINDOWS\Temp\ITAM\Templates\CASM\installer.properties file in notepad

  3. Add the dynamic port number to the following section:

    #----------------------
    #Enter database server name
    DATABASE_SERVER=<database_server_name>
    #Enter database name
    DATABASE_NAME=mdb
    #Enter database server port
    DB_SERVER_PORT=<dynamic_port> *Note: There is no instance name as the casm installer is issuing the port to identify the instance.

    #Provide MDB Administrator Detail
    -------------------------

  4. Save the changes to both installer.properties files

  5. Open the APM Configuration screen (start->programs->CA->APM configuration)

  6. Click 'Retry' next to failed CASM install

  7. Review the CASM install log at
    C:\Windows\Temp\ITAM\ItamCASMInstall<date>.log

The CASM install should complete successfully.

Environment

Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration
Component: