Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> SQL Server >> SQL Server Setup & Upgrade

SQL Server Setup failed to retrieve the SSL Certificate Name

When I try to install SQL 2005 Developer September CTP on Windows XP Professional it returns an error"SQL Server Setup failed to
retrieve the SSL Certificate Name".
I was using a certificate from SelfSSL but removed it. Still no luck?

This appears to be an issue with SQL Reporting Services. If I don't install Reporting Services then I can install SQL 2005. I'm guessing that Reporting Services is now requiring a certificate and doesn't like the SelfSSL certificates? Any ideas?

[562 byte] By [TomGillespie] at [2007-12-22]

«« Can't find "windows.h"
»» Build exe with images from VS2003

# 1

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

chrisleonard at 2007-8-30 >

top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...

# 2

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

jskelly at 2007-8-30 >

# 3

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.

debrucer at 2007-8-30 >

# 4

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/

DanJonesMSFT at 2007-8-30 >

# 5

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.

debrucer at 2007-8-30 >

# 6

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.

pwilliams82 at 2007-8-30 >

# 7

This worked fine!

Thanks again Microsoft and members!

JoeHanlon at 2007-8-30 >

# 8

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.

Devo64 at 2007-8-30 >

# 9

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

Devo64 at 2007-8-30 >

# 10

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

Phantom_ab at 2007-8-30 >

# 11

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.

Devo64 at 2007-8-30 >

# 12

Thx, it goes smoothly now

FangLiu at 2007-8-30 >

SQL Server

SQL Server Setup & Upgrade

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech