How Do I Resolve “Unable to login to database server”?

Enabling TLS to resolve the message by enabling TLS 1.0 in the registry using the register editor.

TLS 1.0 is a protocol used to provide privacy and data integrity between two communicating computer applications.

The following “Unable to login to database server” message could occur if TLS 1.0 is disabled.

null

In order to check to see if TLS is enabled, go into your registry using registry editor.

  1. It is recommended to first back up the registry before making any changes.  Please refer to the Microsoft Backup the Registry article before proceeding
  2. Open Windows Registry by using the RegEdit command from the start menu
  3. Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols

  1. Confirm TLS 1.0 is enabled under protocols
  2. If TLS 1.0 is not enabled change the DWORD Values under Server and Client keys by right clicking and selecting modify
    1. DisabledByDefaul [Value = 0]
    2. Enabled [Value = 1]

  1. After making any changes, reboot the server so the settings can take place.

If you are still receiving the error please refer to our Common Causes for “Could Not Connect to SQL Server” article

For any further assistance please contact Acctivate support for more assistance.