May 22, 2006 at 12:49 pm
so i sit down this morning, and open my Enterprise Manager to connect to
my servers as usual, and BANG!! Get the following error:
[Microsoft][ODBC SQL Server Driver][Shared Memory]Encryption not supported on SQL Server
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (PreLoginHandshake()).
Why do I get this all of the sudden?
Thoughts?
_________________________
May 22, 2006 at 2:17 pm
Had this once and we were on the way to bouncing the server so never had to investigate since it went right after the bounce
Mike
May 22, 2006 at 2:21 pm
well this in particular is on my client work station. get this... i installed
sql on my workstation right, and when i went to register the local instance
i got this error.
this is stupid, crazy-dumb! i don't get it.
_________________________
May 23, 2006 at 5:13 am
Can you run cliconfg.exe to check if the "Force protocol encryption" option is checked ??
May 23, 2006 at 5:28 am
yes. it is enabled actually. should i uncheck this option?
i have to wonder... why is this a problem now. has it always been
enabled by default?
_________________________
May 23, 2006 at 5:37 am
by the way... is it really this simple to resolve? just to uncheck
the encryption option?
_________________________
May 23, 2006 at 6:22 am
Yes, try to uncheck this option. By default this option is unchecked.
May 23, 2006 at 6:24 am
hmm... thats wierd. i never checked it to begin with, but now i know.
many many thanks! this was driving me crazy.
cool.
_________________________
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply