On How to: Enable Encrypted Connections to the Database Engine by Microsoft, we find the following: To configure...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
the server to accept encrypted connections:
- 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
Related Q&A from Adam Machanic
Database Snapshots feature in SQL Server 2005 Enterprise Edition creates read-only files. For these separate databases, our site expert Adam Machanic...continue reading
Multiple readers can sometimes read the same row simultaneously causing a false result. SQL Server 2005 expert Adam Machanic suggests modifying the ...continue reading
Migrating to SQL Server 2005 from SQL Server 2000 is a hefty feat when compared to upgrading from 7.0 to SQL Server 2000. Site expert Adam Machanic ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.