You can take multiple backups of the certificate, with different passwords.

BUT once the certificate is restored to their server (so they can continue to receive and restore your backups,) they...

amy26 (6/21/2016)

---

Hehe yea...

I think I may have figured it out. DoD PKI certs are in a pfx format and they need to be in pvk. I was...

amy26 (6/21/2016)

---

Yea, it has a password according to the IT guy. I dunno if its the format it doesn't like or not. BLAH this is really annoying... its...

Geez, where the heck has the year gone?

We're just under 2 weeks out from the half-way mark of the year...

So far, no, only certificates I created in SQL...

However, are you sure the key file has a password on it? Came across this over on MSDN: unable-to-import-certficate

They had...

ChrisM@Work (6/16/2016)

---

Is this you...

/me jiggles door handle...

/me knocks softly, tries to open door...

/me pokes head into room, quietly calls out "hello? Anybody here?"

/me leaves when no one answers...

Well, I guess the Brazilian...

The listener service they're referring to would be on the Oracle server (presuming that's not the same as the server you're attempting to connect from.)

I'd check with the Oracle DBA...

Yeah, I'd start there. I've not run into this, yet, mostly because the only certs I've needed have been for encrypting the network connection, so those go into the...

If you're backing up a certificate, then SQL creates both the certificate and key files.

So if you don't have the private key file, if you just have the cert file,...

amy26 (6/15/2016)

---

BAH! It didn't fix it when I changed the service to my domain admin account. I wish the error message was more specific... I assume a certificate...

amy26 (6/15/2016)

---

Yes, I'm trying to do it on my local database not to another server. I will check the startup accounts for the services... I think on my local...

To clarify something: Is the SQL Server you're attempting to load this certificate to, also local to your PC, or is it a different system?

If it's a different system,...

I think you might have misunderstood me....

So, just got done converting some views and table-value functions over to stored procedures that I can use instead.

The TVFs and views are for security auditing, they're really just pre-written...