Installation of GSS on SQL 2016 Express Server fails with unable to login error

book

Article ID: 170241

calendar_today

Updated On:

Products

Ghost Solution Suite

Issue/Introduction

When attempting to install GSS 3.2 on a fresh installation of SQL 2016 Express an error is received at the step where the installer authenticates with the SQL server.

Installation Error Message:


We're unable to login to the SQL Server <server name> using Windows NT Authentication. Make sure that you have specified a supported SQL server. 
You may need to use SQL Server Authentication

Cause

TLS Authentication was disabled in the registry

Environment

Windows 2012 R2 Server
SQL Express 2016
Ghost Solution Suite (GSS) 3.2

Other environments may also be affected

Resolution

You should first work through TECH25561 for more common connectivity issues to the SQL DB. 

If the above article does not resolve the issue, enable TLS 1.0 by entered a 1 in the corresponding DWORD keys under the registry path: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols