 |
 |
 |
 |
A blog about Ruby, Rails and other Tech. Mostly.
Back to blog| 3rd Feb 2004, 1:36pm |
I have a setup of MS SQL on my local machine here, which was running fine. But today I started it up, and attempted to connect, but all I got was "Encryption not supported on SQL Server ConnectionOpen (PreLoginHandshake())."
What does this mean? Well, I searched in the help utility that comes with MSSQL. There is a very useful looking page called "Help with Connectivity", which mentions this exact message. It instructs you to look at the online "troubleshooters", and there is a link to them.
However, those troubleshooters ain't there.
Searching on google, and on the MS knowledgebase provides further links to the same non-existent troubleshooters. Good job Microsoft.
Some considerable amount of frustration later, I came across this article, which gave me a clue to the solution. I just needed to remove a setting for "Force protocol encryption" by using the SQL Server Client Network Utility.
I remain in the dark about why this setting had apparantly changed all by itself, but one possible factor was that I installed the latest critical updates from windows update today.
Microsoft's hopeless help, with its links to nowhere cost me an unreasonable amount of time, given that the problem was so simple to solve in the end.
Back to blog