Can't connect to the database - Installation Error

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

While performing the installation of CA Service Management suite in Advanced Availability, database patching fails. In the configure.log we see this message:

11/23 14:03:56.544 INFO  ConfigThread.java      598 Configuration progress : 12 out of 28 tasks completed.
11/23 14:03:56.544 INFO  ConfigThread.java      558 Executing task# 13, task name : Applying patches
11/23 14:03:56.544 INFO  Task.java              214 Running: Applying patches
11/23 14:03:56.560 INFO  PatchDatabaseTask.java   353 Executing altArgs >sql_check_db -c  -s lab-srv-sdm-bg1 -o mdbadmin -d mdb -U mdbadmin -p <DB password> -n lab-srv-sql-v01<
11/23 14:03:57.169 INFO  ?                        ? Process D:\CA\SERVIC~1\bin\sql_check_db.exe completed with exit code 99
11/23 14:03:57.169 ERROR PatchDatabaseTask.java   607 Can't connect to the database.

We also tried to run the command:

sql_check_db -c  -s lab-srv-sdm-bg1 -o mdbadmin -d mdb -U mdbadmin -p <DB password> -n lab-srv-sql-v01

But this returns "ERROR: AHD50072:Unable to log in to SQL Server"

Environment

Release : 17.3

Component :  Service Desk Manager

Resolution

We found that the osql executables were missing.

The SDM install database requirements can be located at:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/installing/installation-prerequisites/database-requirements.html

In a SDM Advanced Availability Configuration, the database Client tools for Microsoft SQL Server are required on SDM standby server, background server, and application servers. This is because the setup uses osql, which Microsoft moved to the Client Tools package in recent releases.