How do I fix encryption failures when upgrading to SQL Server 2005?
We recently upgraded from SQL 2000 to SQL 2005 on WINDOWS 2003. The entire upgrade process has run pretty smoothly aside from encryption. We have ASP.NET 1.x apps that connect to an internal server but fails when encrypted. We have tried all of the steps available on the MS KB and still have not resolved the issue. In “How to: Enable Encrypted Connections to the Database Engine” by Microsoft, we find the following: To configure 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. The problem is when we get to Step 2, there are no certificates available in the dr
Related Questions
- After upgrading SQL Server version 6.x databases to SQL Server 7.0 using the automatic configuration option, the resulting SQL Server 7.0 databases are smaller than their SQL Server 6.x counterparts. Does this mean that there was a problem with the upgrade?
- I have Norton Internet Security, How do I fix SQL Server does not exist or Access is Denied ?
- How do I fix encryption failures when upgrading to SQL Server 2005?
