Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Task Scheduler .vbs pass windows authentication?

Posted on 2015-02-19
2
120 Views
Last Modified: 2015-04-01
Hello,

I am trying to set up a scheduled task using a .vbs that simply opens an .aspx that resides on the same box (WinServer2008 R2 Standard SP1).  The .aspx updates a database nightly.  The problem I am having is that the website is using Windows Authentication and requires credentials.  How can I pass credentials via the .vbs, or is there a better way to go about this?  Anonymous access is not an option, although the process works when it is allowed.

 Call PTRBilling()
 Sub PTRBilling()     
     'On Error Resume Next
     'Declare variables 
     Dim objRequest 
     Dim URL 
     Set objRequest = CreateObject("MSXML2.ServerXMLHTTP.6.0") 
     'Put together the URL link appending the Variables. 
     URL = "http://xxxxxx.org/PTRBilling.aspx" 
     'URL = "https://www.google.com" 
     'Open the HTTP request and pass the URL to the objRequest object 
     objRequest.open "GET", URL, false 
     'Send the HTML Request 
     objRequest.Send 
     'Set the object to nothing 
     Set objRequest = Nothing
     WScript.Echo "Done"
 End Sub

Open in new window


Thanks,
Andrew
0
Comment
Question by:Ahelbling
  • 2
2 Comments
 
LVL 12

Expert Comment

by:FarWest
ID: 40619406
this is the parameter for open function of the object

objRequest.open bstrMethod, bstrUrl, varAsync, bstrUser, bstrPassword
0
 
LVL 12

Accepted Solution

by:
FarWest earned 500 total points
ID: 40619410
but it is better to have a dedicated user with limited privilege to run this url since the password will be passed as string
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Lightweight Networking 9 61
Use GPO script to report finding a certain file 16 15
Android Touch & Google API 7 22
SOC, SIEM, IPS and FW 4 32
Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
In this increasingly digital world, security hacks are no longer just a threat, but a reality. As we've witnessed with Target's big identity hack 2013, Heartbleed in 2015, and now Cloudbleed, companies and their leaders need to prepare for the unthi…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question