InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 05:35:28 GMT20http://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxfor your acount no permission to write the data on the network folder possible soluation : give permissions on network folder for your acountTue, 07 May 2013 07:04:26 GMTsubahan.munthamaduguhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxDid you get solution to this? I have same issue? Agent service account has full access on shared folder. Manually I can create files inside the folder but SQL job fails. I tried using \\Server\folder , \\server\Z$\folder and as mapped network drive but nothing works.Thu, 03 Jan 2013 08:25:50 GMTjosephitesonalihttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxBouncing the box worked for me. I believe it had something to do with SPN registration.Thu, 01 Nov 2012 15:32:27 GMTJon.Morisihttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxCheck that there is no space on the end of the database nameThu, 01 Nov 2012 14:41:47 GMTTaurus07http://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxI'm having the same issue. My sqlservice and agent accounts have full access to the cifs. I can manually browse and create/delete folders while logged on as those accounts. My backup maintenance plan is run by a SQL Server login, but does not complete a backup to the cifs. Fails with access denied.Fri, 05 Oct 2012 14:37:40 GMTJon.Morisihttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspx[url=http://www.sqlservercentral.com/articles/Stairway+Series/72460/]Have a look at the recent article regarding sql server jobs[/url]Thu, 12 Jan 2012 05:00:09 GMTJo Pattynhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxWe're running into the same user. I made sure the following:- running SQL 2008 SQL Agent as a Windows admin account called "SqlService"- ensured that that account has full access to the UNC directory- I can create a backup file to a local folder through the job- it warns me on the manual backup file that it can't verify the UNC location- I tried mapping the UNC to a drive letter without success (cannot find the path specified)- I tried logging in as myself (a windows admin, sql server sysadmin) to backup to any network drive (cannot find the path specified)Just don't know how to proceed from here. I can't get a directory in the job, as asked by Steve Jones.Wed, 11 Jan 2012 15:10:13 GMTandre.quittahttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxFree download [url=http://www.backup-sql-server.com/]EaseUS Todo Backup Advanced Server[/url] to backup your database (2000 2005 2008) with backup schedule (daily weekly monthly) to automatic backup SQL Server.Thu, 03 Nov 2011 23:54:00 GMTislandwinohttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxCapture a Process Monitor trace on the destination server and check if the account requesting access on the share is showing up as anonymous. It could be an impersonation issue.Thu, 07 Apr 2011 12:53:37 GMTtroubleshootingsqlhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxHave you tried relaxing the permissions for the share?Thu, 07 Apr 2011 12:51:02 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxCan you run the "dir" job from Agent and have that work? It's definitely a strange error. It's almost like you have some token or kereberos issue with the job.If you manually run the backup, does that work?Thu, 07 Apr 2011 12:22:47 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxSteve,When i ran accessenum on the box, it did show me that the user i am logged in has read and write access to the shared folder.Wed, 06 Apr 2011 14:51:03 GMTNishtha-486860http://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxNot sure if this will help but I once ran itno something similar.I changed the server name to it's ip address and the unc and is started working.Wed, 06 Apr 2011 12:05:53 GMTdweilhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxit is CIFS.Tue, 05 Apr 2011 15:10:33 GMTNishtha-486860http://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxIt is permissions. OS 5 is access denied from Windows.there has to be something weird going on there. Can you run this on your system and perhaps see permissions and verify?[url]http://technet.microsoft.com/en-us/sysinternals/bb897332[/url]Can you do a "dir > n:\test.txt" in a job with the same credentials?Mon, 04 Apr 2011 16:10:31 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxThe network share - is it by chance a DFS replicated share?Mon, 04 Apr 2011 15:18:08 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxSQL Server Services and the agent runs under same account.Thanks!Mon, 04 Apr 2011 15:07:23 GMTNishtha-486860http://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxIt's definitely permissions. AFAIK, however, it's the SQL Service account, not the agent account, that needs permissions.The agent logs in just like you do from your workstation. The backup is run by the SQL engine, and it's service account needs permission.Mon, 04 Apr 2011 15:02:13 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxYes Im logged into the server as the agent domain account and I can manually create, delete txt files on the shared folder. But when I try to backup the database on the shared folder it fails with access denied error.Mon, 04 Apr 2011 14:59:43 GMTNishtha-486860http://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxapart from the share permissions, does the agent also has the necessary NTFS-permissions (if underlying filesystem is ntfs)?Mon, 04 Apr 2011 14:42:16 GMTJo Pattynhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxI have the similar problem. and the SQL agent has read, write and modify access to the shared folder BUT FULL Control. Please help!!!Mon, 04 Apr 2011 12:55:22 GMTNishtha-486860http://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxAs Jo suggested, check if the SQL Server Agent service account has FULL permissions on the network share.Fri, 31 Dec 2010 00:24:51 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxThe sqlagent (user) has access to the share?Thu, 30 Dec 2010 15:19:18 GMTJo Pattynhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxThanks Elliot,Currently i'm able to backup my sqlserver 2005 databases to a shared folder without any glitch. I'm only having trouble doing the same to my sql server 2008 databases hence the error I stated earlier.Thu, 30 Dec 2010 13:54:17 GMTmashikoohttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxThanks, but I'm not trying to backup to a mapped drive but to a network share. Does the steps you metioned earlier apply?Appreciate!Thu, 30 Dec 2010 13:20:49 GMTmashikoohttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxI have had no end to trouble with mapped drives when not connected as an interactive user. I strongly suggest using a UNC path instead of a mapped drive.CEWIIThu, 30 Dec 2010 13:17:28 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspx[quote][b]mashikoo (12/30/2010)[/b][hr]I'm trying to schedule a back up database task to backup some specific databases to a network folder...[/quote]1- Share a folder located on target remote drive2- Map remote share in local server3- Point backup to mapped driveProblem is that backup speed will be limited by network speed - pretty poor performance.Thu, 30 Dec 2010 12:57:07 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspxI'm trying to schedule a back up database task to backup some specific databases to a network folder but kept getting this error message-" Executing the query "BACKUP DATABASE [XDevSL7Utilities] TO DISK = N'\\..." failed with the following error: "Cannot open backup device '\\fscorp\DynDB-Backup\Backup-vDB2001\Database_backup_2010_12_30_134701_5618693.bak'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:47:00 PM Finished: 1:47:01 PM Elapsed: 1.031 seconds. The package execution failed. The step failed"Any help or guidance will be greatly appreciated.Thu, 30 Dec 2010 12:40:50 GMTmashikoo