SQL Stuff

Force Protocol Encryption Error

i get amazed some times with how long one can be doing sql administraiton, and yet still get blindsided by the strange and unusual. i get this error message one day just starting up my machine. apparently i can’t connect to any of the SQL Servers i have registered in enterprise manager. the situation will drive you nuts cause you don’t know what ‘changed’ to create such a problem. never mind looking over documents about ‘microsoft certificates’ about security and so forth…[more] [Microsoft][ODBC SQL Server Driver][Shared Memory]Encryption not supported on SQL Server [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (PreLoginHandshake())

here’s a quick solution.just go to: start -> run -> type in: cliconfg.execheck to see if this is enabled: “Force protocol encryption”it should NOT be enabled.once this is unchecked you should be able to connect to all your sql servers again. this issue is just plain crazy. thats it. by the way this option should be disabled by default. however; i’ve noticed that it ‘might’ be enabled after installation. possibly due to some other cooperative install config setting for your workstation, or servers. hope this is useful.
Advertisements

Categories: SQL Stuff

Tagged as: , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s