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

Manage Support IDs

Use checkboxes to 'Remove support IDs/Users' or 'Allow to create Cases'
Support IDs for BMC Customer Support Site Guest User
Profiles Which Include    Back to All Support IDs
 

Knowledge Article

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

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.
This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

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
Remedy AR System Server
AR System
Remedy AR System Server with MSSQL.
Attachment(s):