September 30, 2011 at 3:25 am
Hi All,
I am taking full backup & destination is different server. When ever i running the backup it's failed.
1. SQL Server agent should run as administrator but it is running through local system.
Please help me how do i change....
September 30, 2011 at 3:33 am
Hi All,
Now i am able to execute the backup but getting error ...
Sourcespid64
Message
BackupDiskFile::CreateMedia: Backup device '\\172.17.148.63\Mpact_data' failed to create. Operating system error 5(Access is denied.).
Please help me on this........
September 30, 2011 at 3:35 am
The "Local System" account has no network access.
Either change the job owner or run the job through a proxy account.
-- Gianluca Sartori
September 30, 2011 at 3:40 am
No, i have network access & even i am able to access destination from Source server
September 30, 2011 at 3:53 am
Your login has network access permissions, Local System can't access UNC paths.
-- Gianluca Sartori
September 30, 2011 at 4:53 am
Hi,
UNC path is correct, locally & as well as Network also accessible......
September 30, 2011 at 5:07 am
You need to setup the agent job to use an account that has access to connect to the mapped/UNC drive, the local system will not be able to do this! As previously mentioned it may be a good idea to use a proxy account.
September 30, 2011 at 5:46 am
saidapurs (9/30/2011)
Hi,UNC path is correct, locally & as well as Network also accessible......
The thing is, when you run a backup, YOU issue the command, but the backup process runs under the security context that SQL Server is running under. Not your access. So if you're getting errors like this, it's because the security context SQL Server is running under doesn't have access.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 30, 2011 at 6:14 am
Hi Grant,
I got your point, but can you tell me where or what type of security shall i change in SQL SERVER
September 30, 2011 at 6:21 am
saidapurs (9/30/2011)
Hi Grant,I got your point, but can you tell me where or what type of security shall i change in SQL SERVER
Go to the Configuration Manager and look up the SQL Server service for your instance. That's where you define it to run under a particular context. You'll have to restart the instance after you change the security.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 30, 2011 at 6:22 am
Use a service account for SQL Server Service, which has access to UNC drive. However a bad example but if you can access UNC drive with 'domain\user' account configure you SQL Server service to use the same 'domain\user' account.
Please don't forget the rule of 'Least Privileges'.
October 2, 2011 at 10:36 pm
Hi Grant,
Let me know which service should i change, please check the attachment for the reference....
Thanks in Advance...
October 3, 2011 at 5:01 am
The SQL Server service is the one that runs backups.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply