Scheduling a SQL Server Backup (via Scheduled Task Manager)

I have not tried. I do need to mention though that when I run the code on my Dev machine, the API works fine. I believe the problem is isolated to scheduled tasks. Is there some kind of internal security glitch. I would think this would be a common thing to do. Has anyone had success?

 

I already did. The ticket was closed without resolve. I'll do so again:-(

 

Has anyone been able to schedule a sql server backup? I'm losing my mind trying.

Here's the code that gets executed on my scheduled web form:

CustomerApi api = new CustomerApi();
api.Sql2005CreateBackup(ConfigurationManager.AppSettings['ApiKey'], ConfigurationManager.AppSettings['DatabaseName']);

Yes, I'm absolutely certain the the ApiKey and the DatabaseName references are correct.

Here's the exception details:

Message: Server was unable to process request. ---> Access denied.
Source: System.Web.Services
Request: System.Web.HttpRequest
Form:
QueryString: x=2
TargetSite: System.Object[] ReadResponse(System.Web.Services.Protocols.SoapClientMessage, System.Net.WebResponse, System.IO.Stream, Boolean)
StackTrace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at net.discountasp.api.CustomerApi.Sql2005CreateBackup(String key, String databaseName)
at BackUp.Database(String path)
at update.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Here's some variables from the request header:

LOCAL_ADDR 216.177.89.6
REMOTE_ADDR 64.79.161.34
REMOTE_HOST 64.79.161.34
REMOTE_PORT 2687
HTTP_CONNECTION Keep-Alive
HTTP_HOST cappersunit.web120.discountasp.net
HTTP_USER_AGENT DiscountASP.net Scheduled Task Service


My white list contains both the identified IP's here. Yes they're comma separated (216.177.89.6,
64.79.161.34)


Can anyone shed some insight into this issue?

Thanks

 

Can you access other API's without a problem?

rcp
DiscountASP.NET
www.DiscountASP.NET