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
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
"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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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/
http://learn.iis.net/page.aspx/144/how-to-set-up-ssl-on-iis/
ASKER