0

In the connections dialog of Management Studio there is an option to encrypt the connection so that you can force the connection to the remote server to be encrypted.

Is there a way that I can make every connection I make in Management Studio to be encrypted - or in other words, make that box permanently ticked?

NOTE: I do not have control of the SQL Server instances I am connecting to, so I cannot enforce encryption at the server end.

enter image description here

Laurence Frost
  • 101
  • 1
  • 2

1 Answers1

0

If you use registered servers (either locally stored or in a Central Management Server), you can set that property in that connection. Then when you use that stored connection, it'll be encrypted.

Ben Thul
  • 3,024
  • 17
  • 24