Encryption failures when upgrading to SQL Server 2005
There are several criteria required for certificates to be properly loaded by SQL Server 2005, when upgrading. SQL Server 2005 expert Adam Machanic addresses concerns.
On How to: Enable Encrypted Connections to the Database Engine by Microsoft, we find the following: To configure the server to accept encrypted connections:
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
- In SQL Server Configuration Manager, expand SQL Server 2005 Network Configuration, right-click Protocols for
, and then selectProperties. - In the Protocols for
Properties dialog box, on the Certificate tab, select the desired certificate from the drop down for the Certificate box, and then click OK. - On the Flags tab, in the ForceEncryption box, select Yes, and then click OK to close the dialog box.
- Restart the SQL Server service.
Dig deeper on .NET Development for SQL Server
Pro+
Features
Enjoy the benefits of Pro+ membership, learn more and join.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our SQL Server experts
View all SQL Server questions and answers
0 comments
Oldest Newest