August 16, 2013 at 9:54 pm
Hi,
I am trying to backup from my sql 2005 DB which is on windows server 2003 to sql 2008R2 on windows server 2008R2 but getting access denied,
I have tried using SSMS, T-Sql but still getting issue with this.
I have created backup folder on my 2008R2 server and assign the full access to Everyone on security permission, I have added user and also grant the FUll Permission.
1) I tried using SSMS ut didn't work
2) I tried using T-sql, didn't work
I have just install the sql 2008R2 on Windows 2008 R2.
August 17, 2013 at 2:27 am
Have you mapped a drive from the source server to the location on the remote server? You could use this drive letter then to access the remote backup folder.
August 17, 2013 at 6:24 am
What is the service account for the instance you are trying to run BACKUP from? Make sure that it is a domain account. LocalSystem or somesuch is not likely to be succesful.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 17, 2013 at 11:51 pm
"I am trying to backup from my sql 2005 DB which is on windows server 2003 to sql 2008R2 on windows server 2008R2 but getting access denied" (You cant backup to SQL 2008 R2, you can only restore to it.. you might've meant backup to windows server.. just saying).
Erland is right Local system etc won't work. You need a domain account.
Are you manually executing it or is this a job?
When you are manually executing the script, I thought it uses your credentials. Perhaps I might not be right on this one. But on that destination folder, can you need to grant the (Domain account) service account running SQL and your domain login - rights to the folder and try?
-
August 22, 2013 at 10:46 pm
Thanks.
I tried using SSMS and T-sql and logged as administrator and assigned also access to everyone full control but didn't work.
August 23, 2013 at 12:52 am
It is not about what you are logged in as! It is what SQL Server is logged in as!
Open SQL Server Configuration Manager, find the service, select Properties, check the LogOn information. It should be a domain account not LocalSystem.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply