November 4, 2014 at 11:28 pm
On SQL I've attached a new database to my instance however when trying to back this database up to my remote backup server it's stating "Access Denied"
My other databases on the same server/instance are able to backup without issue, what should I be checking when this error occurs?
Also my SQL Service account under 'Services' is not running as a domain account and therefore hasn't got access to the backup location but my other databases are still backing up so I can't see why this would be the issue.
Thanks,:w00t:
November 5, 2014 at 3:51 am
can you supply exact details of the error and details of the current configuration
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2014 at 5:18 am
In addition to the error you're receiving, how are you trying to backup the database? Are you typing "BACKUP DATABASE"... or is a database job trying to back it up? I'm asking because if it's a job, then you need to look at the security context of the SQL Agent service instead.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply