Take the 2-minute tour ×
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.

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

1 Answer 1

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: http://kushagrarakesh.blogspot.com/2011_10_01_archive.html

share|improve this answer

Your Answer

 
discard

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.