Remedy - Server - AR with MSSQL installation error:"[Unresolved database error: <b>Login failed for user 'sa'. ClientConnectionId:...]"

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    AR System


    APPLIES TO:

    Remedy AR System Server with MSSQL.



    QUESTION:

    When installing a fresh AR Server on a MSSQL Database with multiple instances present the install log shows:
    .....................
    ....SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDBAUserInputValidationTask,
     
    LOG EVENT {Description=[INVALID_DATABASE_UNKNOWN_ERROR[Base64:TGzA=];INVALID_DATABASE_UNKNOWN_ERROR[Base64:TG9nzA=]],
    Detail=[Unresolved database error: <b>Login failed for user 'sa'. ClientConnectionId:a36f698c0</b>

    .....................


    This error indicates a problem with the sa user and/or the database instance port.


    ANSWER:

    Solution :
    Make sure the right port number is used for the Database instance or a dynamic port is not set for the instance.

    To check the local IP as well as the listening Port number
    1- Open SQL Server Management Studio.


    2- Connect to the database engine for which you need the port number.

    3- Run the following query against the database: 
             select distinct local_net_address, local_tcp_port from sys.dm_exec_connections where local_net_address is not null;
     

              User-added image


    The above query shows the local IP as well as the listening Port number in this instance it is 1433 default port

    To check is a port is Dynamic port:
    1- Open SQL Server Configuration Manager.
    2- Expand SQL Server Network Configuration.
    3- Click on Protocols for <Instance Name>.
    4- Right-click on TCP/IP and click on Properties.
    5- Click on the IP Addresses tab.
    6- Scroll down to IPALL.
    7- The port being used will either be listed as TCP Port (which is a static port) or TCP Dynamic Port.

              User-added image

              User-added image


    Article Number:

    000164216


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles