• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

How do I configure / request a certificate for SQL 2008.

Greetings experts,

I am new to SQL, but I am well versed on creating certs for exchange.  I would like to create a cert for a SQL site so the we can connect to it via https from the outside of our firewall.
I see this article, http://support.microsoft.com/kb/316898 and it looks like it explains installing the cert pretty good.
Is there a step by step in creating the public cert?
I went into mmc, certificates.  Then personal, all task, request new cert.  Then I can use template or create own.  If I create my own, it asks for URL.  I put in the url I want to use, but I don't think that's right.
I'll be using Godaddy to create the cert, don't want to have each client to have to download the cert.
OS of web server= 2008 r2 sp1 ent with IIS7, OS of SQL server =  2008 32 bit ent , with sql 2005 installed.

Also, when I create the cert at godaddy, can I just use a basic ssl cert with one name?  
I've never created a cert for anything but exchange.

Thank you,
Kacey

Thank you,
Kacey
0
Kacey Fern
Asked:
Kacey Fern
  • 3
1 Solution
 
Kacey FernSystem EngineerAuthor Commented:
sorry the question says sql 2008, it's sql 2005
0
 
lcohanDatabase AnalystCommented:
"don't want to have each client to have to download the cert." - I can't see how can you authenticate them if they dont have a trusted certification installed localy.

In my opinion you must export the server certificate's Trusted Root Certificate Authority (CA) to a place from where the client computer can access the file and later on import the certificate on the client computer.

0
 
Kacey FernSystem EngineerAuthor Commented:
I just ended up putting a cert on the top level of IIS 7.  It will be the only site on the server, so it is all I needed.  So if anyone else needs to do this, just click on the server in IIS and the server certificate.  From there it is pretty easy.

http://learn.iis.net/page.aspx/144/how-to-set-up-ssl-on-iis/
0
 
Kacey FernSystem EngineerAuthor Commented:
I just ended up putting a cert on the top level of IIS 7.  It will be the only site on the server, so it is all I needed.  So if anyone else needs to do this, just click on the server in IIS and the server certificate.  From there it is pretty easy.

http://learn.iis.net/page.aspx/144/how-to-set-up-ssl-on-iis/
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now