April 5, 2017 at 1:09 pm
A SQL authenticated user have db_owber access on database. When trying backup then its giving below error.
Operating system error 5 acess denied to path.
can you all suggest how to resolve. for other windows authenticated users its working fine for same backup path.
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
April 5, 2017 at 1:25 pm
I'm presuming you mean a SQL Login when you say "A SQL authenticated user..." That being the case, it's immaterial, the OS is denying access to where you're trying to take the backup. You need to give either the SQL Agent Service Account (if it's an Agent job,) or the SQL Server Service Account (if it's not an Agent job) access to the backup path.
That's also why your Windows Auth users *don't* have a problem, they have access to the backup path.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply