June 27, 2008 at 1:34 pm
I have recently moved all my development database to a new server and now am trying to set up to back up all the databases. I have set all the permissions to the folder to allow the backup to another serve but I keep getting an access denied to the back up location. I have all the permissions necessary sysadmin and I still get the error. I am guessing I am missing something extremely simple but it is driving me crazy. If anyone has any suggestions on what I can try please let me know.
Thanks
June 27, 2008 at 1:37 pm
Does the account running SQL have access to this folder?
June 27, 2008 at 1:38 pm
sorry, are you trying to backup to a different server than SQL is running on?
is SQL running under the system account or a domain account?
---------------------------------------------------------------------
June 27, 2008 at 2:00 pm
Yes. I am trying to back up to a different sql server. I have a domain account running services and that same domain account has permissions to the folder on the back up server.
June 27, 2008 at 2:02 pm
Pam Ozer (6/27/2008)
Yes. I am trying to back up to a different sql server. I have a domain account running services and that same domain account has permissions to the folder on the back up server.
I would double check that ... this is definitely a permissions issue from your service account. Can you access that file path/share using the account in which is running your SQL Server?
June 27, 2008 at 2:08 pm
Have you checked both share level and NTFS permissions?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply