Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL backup to network drive Expand / Collapse
Author
Message
Posted Friday, November 30, 2012 10:02 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, March 21, 2014 4:05 AM
Points: 79, Visits: 188
Our 20 SQL Servers all running under "Local System account".
Backup to network share doesn't work - Error.
I guess because local account doesn't have access to network folder. Even when I add "Everyone" FULL CONTROLL to the folder.

What is the solution?
Does it mean we have to change SQL Server service account to Domain account on all 20 servers?
Post #1391438
Posted Friday, November 30, 2012 10:32 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 22, 2013 10:13 AM
Points: 79, Visits: 200
More likely that you will need to change the SQL Agent service account to a domain account that has access, not the SQL Server service account.
Post #1391453
Posted Friday, November 30, 2012 11:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:51 AM
Points: 5,958, Visits: 12,839
if using local system you need to allow the machine account access to the network share

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1391467
Posted Friday, November 30, 2012 12:35 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, March 21, 2014 4:05 AM
Points: 79, Visits: 188
I don't even know how that "Local System account" looks like.
I guess it's different on each machine.
I tried to work around and granted "Everyone" FULL CONTROL on that network folder but it didn't help.

I did a test on my local SQL 2012 Express. I had the same setting - Local System account.
As soon as I changed it to my Domain account - Backup successfully created a file on network share.
Post #1391504
Posted Friday, November 30, 2012 1:48 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 22, 2013 10:13 AM
Points: 79, Visits: 200
I think you only need to change the SQL Agent service account, not the SQL Server service account.
Post #1391546
Posted Friday, November 30, 2012 2:09 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 32,781, Visits: 14,942
LocalSystem is local to the machine. You need an account that has rights to get to the network.

You should set a service account that's a domain account, with Everyone permissions and then specific permissions to certain shares for backup.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1391551
Posted Monday, December 03, 2012 8:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:48 AM
Points: 2,507, Visits: 3,645
If you know any account having enough rights on that drive give it as proxy account on SQL Server properties--> Security
Post #1391987
Posted Monday, December 03, 2012 8:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:58 AM
Points: 5,077, Visits: 8,918
sqlGDBA (11/30/2012)
I think you only need to change the SQL Agent service account, not the SQL Server service account.

Yes, if you're running all your backups as scheduled jobs, that's true. But if you expect to run ad hoc backup (or restore) commands from SSMS, for example, then I think the SQL Server service also needs access.

John
Post #1391991
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse