Using CA issued Certificates for SQL Certificate Encryption
- From: "Jediah L" <rife@xxxxxxxxxxxxx>
- Date: Tue, 20 May 2008 16:17:37 -0400
I am trying to create a certificate in SQL Server 2005 using the CREATE
CERTIFICATE TSQL statement, however, the certificates that I have are in CER
and PFX format - for some reason, SQL Server 2005 is requiring a PVK file
rather than the Microsoft standard private key exchange format of PFX.
Anyway, I have the PFX file, and I tried to supply that as the private key,
hoping that perhaps SQL Server was smart enough to use (convert) the PFX
Microsoft standard format for private key files.... no luck....
I've found at least one freeware utility to convert PFX to PVK - however,
I'm a little cautious in using freeware utilities from unknown sources to
manipulate something as important as my certificate files.
Does anyone know how to convert PFX files to PVK files using a Microsoft
supplied toolset, or some way to get SQL 2005 to accept the PFX file?
I've found examples using makecert.exe - however, I already have the
Certificate that was issued by a trusted certificate authority that I'm
trying to use for this function, rather than making one from scratch.
Thanks in advance!
Jediah L.
.
- Follow-Ups:
- RE: Using CA issued Certificates for SQL Certificate Encryption
- From: "Peter Yang[MSFT]"
- RE: Using CA issued Certificates for SQL Certificate Encryption
- Prev by Date: Re: Application error event every minute on MSSQLSERVER : "Failure Audit: Login failed for user 'NT AUTHORITY\SYSTEM' [Client: <local machine>]
- Next by Date: Re: Trying to set up a SQL Server Agent Account and I hit a wall....
- Previous by thread: Application error event every minute on MSSQLSERVER : "Failure Audit: Login failed for user 'NT AUTHORITY\SYSTEM' [Client: <local machine>]
- Next by thread: RE: Using CA issued Certificates for SQL Certificate Encryption
- Index(es):
Relevant Pages
|
