Scheduling a SQL Server Backup (via Scheduled Task Manager)

[jfudsaouedsfn]

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?

[bruce]

This may be related to a bug w/ the white listing IP. Please create a support ticket referencing this post and we'll check to make sure.


Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[jfudsaouedsfn]

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

[jfudsaouedsfn]

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.AppSe ttings['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.SoapCli entMessage, System.Net.WebResponse, System.IO.Stream, Boolean)
StackTrace: at System.Web.Services.Protocols.SoapHttpClientProtoc ol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.Invoke(String methodName, Object[] parameters)
at net.discountasp.api.CustomerApi.Sql2005CreateBacku p(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.Cal lback(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

[raymondp]

Can you access other API's without a problem?

rcp
DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)