Archive for January 2009

SQL Server Setup failed to retrieve the SSL Certificate Name

13 January 2009

I had this problem while installing my new computer with Sql Server 2005. It was because Reporting Services tries to be a little too clever and do something with SSL if you have it installed. As it’s on a development machine and I’m using SelfCert to test SSL, it’s not a true SSL certificate. This causes the Sql Server installation wizard to give up the ghost with the annoying error message:
SQL Server Setup failed to retrieve the SSL Certificate Name

To fix this, open up IIS manager, go to your default site > properties > Directory security > server certificate and remove certificate. Now install SQL Server 2005 with reporting services and then re-selfcert your localhost again.

Posted in Technical | 3 Comments »