I have created a certificate and am taking a backup to a .cer file so
that an Initiator service can use it for sending messages:
BACKUP CERTIFICATE InstTargetCertificate
TO FILE = N'E:\Personal\me\Tgt.cer';
GO
The .cer file gets created. But I get a message saying "Acces is
denied" as if the file is currently in use when I try to copy it to
any other directory.
Can you explain why this is happening?
I have CREATE CERTIFICATE permission and CONTROL permission on the
certificate created.
I am using SQL server 2005 on Win XP.
Thanks,
Yash
TheRealRobbie - 25 Jun 2008 15:26 GMT
Yash,
In all probability you already checked, but does the NT user you try to copy
the file with actually have read permission on it?
> I have created a certificate and am taking a backup to a .cer file so
> that an Initiator service can use it for sending messages:
[quoted text clipped - 13 lines]
> Thanks,
> Yash