Backing up Encryption Master Key

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Car - 26 Oct 2006 16:46 GMT

Hello,
I have problems backing up the Master key. The message is cannot write into
file 'file path' verify that you have the write permissions. I don't
understand why because I am using user dbo and defaul schema dbo on the
database.

If someone can help me to clarify the permissions part.

Thanks for your help.

Reply to this Message

Laurentiu Cristofor [MSFT] - 26 Oct 2006 18:39 GMT

Make sure the SQL Server service account has write access to the path where
you want to save the file.

Thanks

Signature

Laurentiu Cristofor [MSFT]
Software Development Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/

This posting is provided "AS IS" with no warranties, and confers no rights.

> Hello,
> I have problems backing up the Master key. The message is cannot write
[quoted text clipped - 6 lines]
>
> Thanks for your help.

Reply to this Message

Car - 26 Oct 2006 19:41 GMT

Well I am not login as sa. I am using windows authentication and the login
user I have is member of the Administrators group on the local computer where
I am trying to save the file containing the backup of the master key.

Thanks for your help anyway.

> Make sure the SQL Server service account has write access to the path where
> you want to save the file.
[quoted text clipped - 11 lines]
> >
> > Thanks for your help.

Reply to this Message

Laurentiu Cristofor [MSFT] - 27 Oct 2006 02:00 GMT

How you connect and the permissions you have don't matter in this case -
when you go outside the server, you go out with the service account
credentials, not with the credentials you connected to the server.

So, find out what account SQL Server is running as, and make sure that
account has access to the location where you want to save the backup file.

Thanks

Signature

Laurentiu Cristofor [MSFT]
Software Development Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/

This posting is provided "AS IS" with no warranties, and confers no rights.

> Well I am not login as sa. I am using windows authentication and the
> login
[quoted text clipped - 20 lines]
>> >
>> > Thanks for your help.

Reply to this Message

Car - 27 Oct 2006 18:15 GMT

I got it. I find out that the SQL Server Account I was running does not have
permissions on the Local computer. Now I am running the backup statements as
a job under the right account and I have to create another job to restore the
backup of the master key into the suscriber database.

Thanks again for your assistance.

> How you connect and the permissions you have don't matter in this case -
> when you go outside the server, you go out with the service account
[quoted text clipped - 29 lines]
> >> >
> >> > Thanks for your help.

Reply to this Message