SQL Connection Error: Client unable to establish connection because an error was encountered during handshakes before login

Problem

When logging in to ProTracker Advantage, the following error is received while connecting to SQL Server:

Client unable to establish connection because an error was encountered during handshakes before login

Cause

This error may be caused by low memory on the server hosting the SQL instance or issues with local DNS and/or the Domain Controller.

Solution

Option 1: Reboot the server hosting the SQL Server instance.

Option 2: Change your login to use the server's IP address instead of its name. For example, change YOUR_SERVER_NAME\SQLEXPRESS to SERVER_IP_ADDRESS\SQLEXPRESS.  If you are not sure of the server's IP address, type "ping YOUR_SERVER_NAME" at the command line.

Have more questions? Submit a request

0 Comments

Article is closed for comments.