Issue pointing GSS Server to new SQL database

Products

• Ghost Solution Suite

Issue/Introduction

The Ghost database and console were on the same server, but we are trying to move the database to dedicated SQL server. The Ghost server version is RU11 running on Windows Server 2016, and the SQL Server is 2022. Our database team believes it's a SQL driver issue. The ODBC Data Source Administrator process is throwing error 772 and 18 when trying to connect to the off box SQL server. The account I'm using has rights to the new database. 

Cause

Most likely due to TLS capabilities of each operating system. 

Resolution

In this case, upgrading the GSS server Operating System (OS) from Server 2016 to Server 2022 resolved the issue.