sql_check_db -c Exit Code 99 after Management Sudio / ODBC Driver update

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

Updated the ODBC 17 driver as well as MS SQL Server Management Studio to the latest versions from Microsoft and found that SDM Services will not start.

Under the SDM install log directory:

stdlog log indicates:  Command returned non-zero exit code Command sql_check_db -c Exit Code 99
checkdb log indicates  Reason:  Unknown error

SQL Server Management Studio is working and can connect to the database.

Environment

Release:  17.4 and above

Broadcom Service Desk Manager, running on MS SQL Server 2022 (remote DB Server)

Cause

The install of the ODBC and SQL Server Management Studio updates may have also deinstalled the SQL Native Client 11, which is a requirement for SQL Server 2022.  

Resolution

Download and install the SQL Native Client 11, named as Microsoft SQL Server 2012 Native Client.  Another MS link reference is available here.

Please be wary of any OS requirements as certain install options for this component have varying OS prerequisites and compatibilities.

Additional Information

Please review AHD50060:Database check FAILED - sql_check_db -c Exit Code 99: Possible Causes for additional causes.

A way to test if the SQL Native Client is present:  Search for any "sqlncli" files, such as sqlncli11.dll, sqlnclir11.rll, or s11ch_sqlncli.chm in %SYSTEMROOT%\system32\ of the SDM install server.   The presence of at least the sqlncli11.dll file will indicate the SQL Native Client 11 is in place.

It is strongly advised that any updates to your SDM instance should first be tested in a non-production instance before attempting in production.