After installation or upgrade of Service Desk Manager (SDM) to 17.0, it no longer works and is throwing SQL related errors.

Document ID : KB000008007
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

After the installation or upgrade of Service Desk Manager to version 17.0, the application no longer works due to connection issues with Microsoft SQL Server.

Running "sql_check_db -c" yields:
ERROR: AHD50072:Unable to log in to SQL Server

 

After running "sql_check_db -c" the checkdb logs located in "NX_ROOT\logs" also shows:
Failed to logon to SQL Server (<SQL SERVER HOSTNAME>) Reason: Unknown Error

Environment:
Service Desk Manager 17.0Microsoft SQL Server
Cause:

Starting with Service Desk Manager 17.0, an additional prerequisite was added which is the "Microsoft SQL Server Native Client" which was not a requirement in previous versions.

Resolution:

The latest version of the SQL Server Native Client is "Microsoft SQL Server Native Client 2012". Please note that Microsoft SQL Server Native Client 2012 will work with both SQL Server 2014 and SQL Server 2016 as there is no SQL Server Native Client 2014 or 2016. "Microsoft SQL Server Native Client 2012" can be found in the Feature Pack for SQL Server 2012 which is located at:

https://www.microsoft.com/en-us/download/details.aspx?id=43339

The specific file you are looking for is "sqlncli.msi" Please note there is a 64-bit version and a 32-bit version.

 

Download the one that matches the Operating System's architecture and install it on every Service Desk Manager server.

After installation verify the issue is resolved by running "sql_check_db -c" again. It should now be successful.

Additional Information:

https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client