May 21, 2011 at 10:13 am
Hi,
Am using sql server 2000 sp4.
I have installed the ssl certificate on sql server machine.
I logged in as sqk server service and installed the ssl certificate.
Now my question is, can we install the certificate into sql server using a different account other than sql service account.
If so, how to do that.
Can anyone provide the any links for steps to do that?
Thanks in Advance.
May 23, 2011 at 9:23 pm
Here's what you must do to install the certificate in order to encrypt connections. It must be done for the computer account, not the SQL Server service account. Here's how:
How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console
K. Brian Kelley
@kbriankelley
May 23, 2011 at 10:08 pm
Thank You.
One question, can i remove the existing certificate using which i have installed using serveice account.
again, open mmc and this using computer account can i loaded it back?
May 24, 2011 at 5:27 am
Yes. But in actuality, you don't have to. However, if you want to remove it, bring up MMC, add the Certificates Snap-In and choose Service Account. If you administrator rights on the server, you don't have to log on as the SQL Server service account. Then you can close out, and repeat starting up the Certificates Snap-In to add the certificate to the Computer account.
K. Brian Kelley
@kbriankelley
May 24, 2011 at 10:47 pm
Fine. Thanks for the information.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply