| Computers Forum Index » Computer - Databases - MS SQL Server » Problem setting up SSL certificate on SQL Server 2005... |
|
Page 1 of 1 |
|
| Author |
Message |
| Chris... |
 Posted: Mon Oct 12, 2009 2:25 pm |
|
|
|
Guest
|
Hello all. I am trying to setup SSL encryption on my SQL Server 2005
machine in order to encrypt the data in transit between my client
machines and the server. My SQL Server is running on a Windows Server
2003 Standard and my Certificate Authority is running on a Windows
Server 2008 Enterprise machine. Here are the steps I follow to get
this up and running.
* Open up mmc on my machine running SQL. Add the Certificates
snap-in .
* Right click on Personal store and Request New Certificate. Get
message that CA got the request
* Go to my machine running CA, Open up certsrv, find my request in
Pending Request and issue request
* Go to Issued Certificates and open it up. Export Certificate to
file.
* Copy file over to my SQL machine.
* Install certificate in the Personal store.
So up to this point everything seems cool. I then go to my SQL Server
Config manager and set Enforce Encryption to Yes. The problem is that
the certificate is not showing up on the Certificate tab. After lots
of reading I found out that the certificate seems like a valid
certificate except for the fact that when I open up the Certificate
from the mmc and look at the General tab I dont see the line "You have
a private key that corresponds to this certificate." So it seems like
somewhere along the line the private key is not getting to my machine
running SQL Server.
Additionally, whenever I request a certificate the option to 'Make
this key exportable' option is always grayed out.
I followed this exact same process to install a certificate on a
machine running Windows Server 2008 Standard with SQL Server 2005 and
everything works fine. I've tried making a new template with the
option to make the key exportable selected but for some reason I
cannot create a new certificate based on that template.
Any help on this would be greatly appreciated.
Thanks |
|
|
| Back to top |
|
|
|
|
