Get error dialog box during installation on Ghost Solution Suite Database authentication

Products

• Ghost Solution Suite

Issue/Introduction

During the installation of Ghost Solution Suite a Dialog box is displayed with: 

"We are unable to login to the SQL Server <SQL server instance> using Windows NT authentication. Make sure you have the supported SQL Server"

Environment

Release: GSS 3.3

using Domain Credentials

Using supported SQL server 2019

 

Cause

In the SQL server error.log this is displayed: 

2023-06-09 15:44:43.74 Server       The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/<SQL server instance> ] for the SQL Server service. Windows return code: 0x200b, state: 15. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.

2023-06-09 15:44:43.74 Server      The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/<sql server instance>:57520 ] for the SQL Server service. Windows return code: 0x200b, state: 15. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.

Resolution

The SQL server SPN needs to be registered with kerberos:

Perform manual registration with: setspn -S MSSQLSvc/<myhost.redmond.microsoft.com>:1433 <redmond\accountname >

Refer to this Microsoft Document on the issue with SPN\Kerberos:

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/register-a-service-principal-name-for-kerberos-connections?view=sql-server-ver16