Re: Backing up Encryption Master Key

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.

"Laurentiu Cristofor [MSFT]" wrote:

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

--
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.

"Car" <Car@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DFF1B05E-DE27-4C72-BCE5-16C640CDFCB3@xxxxxxxxxxxxxxxx
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.

"Laurentiu Cristofor [MSFT]" wrote:

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

Thanks

--
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.

"Car" <Car@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF3C125B-D6D3-4304-87F2-C332DD562626@xxxxxxxxxxxxxxxx
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.






.

Relevant Pages

  • Re: Execute Persmission denied on object sp_OACreate
    ... If so what access and permissions. ... The account is a windows account. ... One method to test permissions is to log in to your SQL Server box using the ... >>> SA account password and gaining access to the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Specifying a logon account for SQL Server 2005 services
    ... As I mentioned using a Windows domain account with no permissions is the ... configured only for very specific server and memory configurations. ... account to use while installing SQL Server, will SQL Server give this account ...
    (microsoft.public.sqlserver.security)
  • Re: simple security question (need refresher)
    ... If IIS is configured for anonymous access and you connect to SQL Server ... using Windows authentication, the IIS anonymous account ... this account or roles that this account is a member of. ... Permissions are required only on objects directly accessed by the ...
    (microsoft.public.sqlserver.security)
  • Re: "Access denied" with xp_cmdshell (!)
    ... But problem is that I have tried to give for that account full control ... restart Sql Server for those permissions to take effect. ...
    (microsoft.public.sqlserver.security)
  • Re: "Access denied" with xp_cmdshell (!)
    ... Does the command work fine if you execute it from a prompt started as the ... service account? ... Have you checked both the permissions for the share and for the file? ... restart Sql Server for those permissions to take effect. ...
    (microsoft.public.sqlserver.security)