The client and server cannot communicate, because they do not possess a common algorithm

-

In this post, I describe how to fix the error:

"A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The client and server cannot communicate, because they do not possess a common algorithm.) (.Net SqlClient Data Provider)

Error Number: -2146893007"

Screenshot of error "The client and server cannot communicate, because they do not possess a common algorithm"

Cause

This error can occur when TLS 1.0 is disabled (perhaps for security compliance purposes) and you try to connect to a version of SQL server that has not been updated to support later versions of the protocol e.g. TLS 1.1 or TLS 1.2.

It can occur on SQL Server 2008, 2008 R2, 2012 and 2014.

This error occurs when TLS 1.0 is disabled on the computer connecting to the SQL server.  If TLS 1.0 is disabled on the SQL Server, after a delay, a different error can occur:

"The system cannot find the file specified"

Resolution

Ensure the SQL server is updated to support a common algorithm that is enabled i.e. TLS 1.2.  You can check which update is required on this Microsoft support article:

KB3135244 - TLS 1.2 support for Microsoft SQL Server

Alternatively, enabling TLS 1.0 on both the computer trying to connect to SQL and the SQL server will resolve this issue.  However, please note that TLS 1.0 should be disabled as it is no longer considered secure.


Video

YouTube link: The client and server cannot communicate, because they do not possess a common algorithm


Related Posts

- Database is not configured for database mirroring. (Microsoft SQL Server, Error: 1416)

- Database cannot be opened. It is in the middle of a restore. (Error 927)

Comments

Post a Comment

Popular posts from this blog

LG TV This app will now restart to free up more memory

-
Image
This post describes how to fix the error "This app will now restart to free up more memory" which can occur when using apps such as Netflix on an LG TV after just a few minutes of use. Resolution To resolve the issue, unplug the TV then press the on/off button for 10 seconds.  Wait a further 20 seconds then plug the TV back in and turn it back on. Apps should now run without the error. Edit: The on/off button on my LG TV is directly under the standby light on the bottom of the TV. Edit: I didn't have to do this myself but one person who has left a comment said that clearing all browsing data worked for them.  I have written a post explaining how to do this: LG TV Clear All Browsing History Data . Edit: A few other people have also suggested turning off quick start in settings (and if it's already off, turn it on then off again).  I have written a post explaining how to do this: LG TV turn off Quick Start in settings Related Posts -  LG TV delete/remove/hide ch
Read more

LG TV Clear All Browsing History Data

-
Image
This post describes how to clear all browsing history data from an LG TV. This is one way to resolve the error " This app will now restart to free up more memory " sometimes seen on LG TVs. Process The process to clear all browsing history data is as follows: 1. Press the Home button on the remote control and keep pressing right until you find the Web Browser then open it. 2. Scroll the wheel on the remote control to reveal the pointer on screen, then press the three dots stacked vertically (located in the top right of the screen, next to the close button) to open the Menu. 3. Select Settings from the Menu. 4. Scroll to the bottom of the Settings to reach the Clear Browsing Data section. 5. Press the Clear All Browsing Data button then press Yes to confirm. Related Posts -  LG TV turn off Quick Start in settings -  LG TV move or delete apps and shortcuts on home screen
Read more

LG TV turn off Quick Start in settings

-
Image
This post describes how to turn off Quick Start on an LG TV. This is one way to resolve the error " This app will now restart to free up more memory " sometimes seen on LG TVs. Process The process to turn off Quick Start on my LG TV is as follows: 1. Press the Settings (cog icon) on the remote control, this opens the side settings menu on the right hand side of the TV screen. 2. Go down to All Settings (the three dots icon that turns into a cog icon on the screen) then click. 3. Go down until you reach General (the cog and spanner icon) 4. Press right then down until you reach Quick Start+ (note: you may need to select Additional Settings before doing this on some LG TVs). 5. Toggle Quick Start+ to the off position (the circle should slide to the left): Related Posts -  LG TV Clear All Browsing History Data -  LG TV move or delete apps and shortcuts on home screen
Read more