Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to set the server to force encryption when I hit apply the message saying that it will take affect after restarting pops up, but when I open the box again its back to NO as nothing was.

Also my self signed trusted certificate is not in the list. I'm not sure if thats the same issue or not.

enter image description here

share|improve this question

The problem is that I don't have the rights to write to the registry that causes the issue.

(It would be nice if sql would throw an error not just close the box without saving).

I found the registry key to edit here:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.