SQL Server Setup failed to retrieve the SSL Certificate Name

SQL Server Setup failed to retrieve the SSL Certificate Name

• ywz

  When you have a certificate installed, the second step of the Web Server Certificate Wizard (at "[Default]Web Site>>Properties>>Directory Security>>Server Certificate...") should show "Remove Certificate" as an option. When I selected this option and removed my SelfSSL created certificate, the SQL 2005 installation ran successfully.
  

• mario.muja

  I had SSL Certificates working with the April CTP, did not try with June, and got this same error with September.  We resolved to defer SSL until RTM; but this is RTM and it's here, so we're looking for a fix.  It is not acceptable to deploy reporting services without SSL.
  
  I will go to beta place in a bit and report it as a bug; but if anyone else has the solution now, please feel free to respond.
  
  
  

• Sébastien Nunes

  It's not necessarily having selfssl installed, this problem will occur if you have any ssl certificate applied to your web server.

  Look in IIS admin, right mouse click on site, click properties, click Directory Security and check to see if there is an SSL cert assigned to the web site. If so, remove it (you can add it back later using the information from the link I posted).

  If you don't have an SSL cert installed, then the issue is most likely not related to this post. You may need to provide more information.

  
  
  

• Colin Josey

  I am having the same problem with a Windows Server 2003 installation.  In the past setups, Reporting Services would just warn you if you did not have an SSL certificate installed to support Reporting Services over SSL.  So now is it just crashing instead   Guess we should be glad this one wasn't the RTM!   :op
  
  Any workarounds, anybody
  
  Thanks,
  Chris
  

• tylerpro

  Back again. Here is the info I was looking for - the problem is explained and resolved here:

  http://www.sqlservercentral.com/columnists/drussell/sslcertificatesonsqlserver2005forreportingservices.asp

  
  
  

• enric vives

  This worked fine!

  Thanks again Microsoft and members!

  
  
  

• anukirthi

  I got the same error as well.  Selfssl had been previously used to install a cert with IIS for ssl testing.  I removed the cert from iis and reporting services installed fine.
  
  Good luck
  
  Jay Skelly
  Microsoft Regional Director
  

• spotl

  Hi Everyone!

  Ok, i never installed that SelfSSL tool and I am running into that exact same error.

  I got SQL installed, without the Reporting tool, so how do I install the reporting portion of

  SQL 05

  Thanks!

  Thomas

  
  

• NotTaken

  Thx, it goes smoothly now
  

• mamo

  Wait just one minute...am I missing something Removing the cert fixes the install problem...but now there is no ssl installed. I need both!

  When I install a new certificate using self ssl - reporting services will no longer operate.

  So, how can I run both SSL and reporting services on my development machine...no one is answering that question.

  
  
  

• malkie

  The certificate is one issued by executing selfSSL.exe in the IIS toolkit.  There is no problem running setup with no certificate; but we must have SSL.  BTW, there does not appear to be any way in the IIS Manager to remove a certificate: create, assign, import, move and Edit are the only options.  selfSSL doesn't have the option either.  The certificate generated by the toolkit worked with April, so it's not like it just won't work; but this does not appear to be a solution.
  
  

• Paul Stovell

  Chris,
  
  IIS still thinks it has a certificate when it really doesn't. Clean up the certificate by going to IIS Manager and removing the certificate from IIS. We you rerun setup it should succeeded.
  
  Dan
  http://blogs.msdn.com/dtjones/
  
  
• SQL Server Setup failed to retrieve the SSL Certificate Name