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 am using SQL server 2005 on Win 2003 server.


Thanks,
Yash

Yash

Do you have appropriate permission to execute the BACKUP CERTIFICATE

see BOL

regards



"Yashgt" <yashgt@gmail.com> wrote in message
news:bcdf2932-cae1-4206-b3d1-fee65a84c73b@s21g2000prm.googlegroups.com...
>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 am using SQL server 2005 on Win 2003 server.
>
>
> Thanks,
> Yash