InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 21:23:55 GMT20http://www.sqlservercentral.com/Forums/Topic1391438-1550-1.aspx[quote][b]sqlGDBA (11/30/2012)[/b][hr]I think you only need to change the SQL Agent service account, not the SQL Server service account.[/quote]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.JohnMon, 03 Dec 2012 08:44:13 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1391438-1550-1.aspxIf you know any account having enough rights on that drive give it as proxy account on SQL Server properties--> SecurityMon, 03 Dec 2012 08:39:59 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1391438-1550-1.aspxLocalSystem 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.Fri, 30 Nov 2012 14:09:47 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1391438-1550-1.aspxI think you only need to change the SQL Agent service account, not the SQL Server service account.Fri, 30 Nov 2012 13:48:18 GMTsqlGDBAhttp://www.sqlservercentral.com/Forums/Topic1391438-1550-1.aspxI 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.Fri, 30 Nov 2012 12:35:37 GMTRVOhttp://www.sqlservercentral.com/Forums/Topic1391438-1550-1.aspxif using local system you need to allow the machine account access to the network shareFri, 30 Nov 2012 11:01:27 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1391438-1550-1.aspxMore 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.Fri, 30 Nov 2012 10:32:57 GMTsqlGDBAhttp://www.sqlservercentral.com/Forums/Topic1391438-1550-1.aspxOur 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?Fri, 30 Nov 2012 10:02:53 GMTRVO