Solved

Task Scheduler .vbs pass windows authentication?

Posted on 2015-02-19
2
134 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
[X]
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
  • 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

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

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

This article describes my battle tested process for setting up delegation. I use this process anywhere that I need to setup delegation. In the article I will show how it applies to Active Directory
This article demonstrates probably the easiest way to configure domain-wide tier isolation within Active Directory. If you do not know tier isolation read https://technet.microsoft.com/en-us/windows-server-docs/security/securing-privileged-access/s…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

710 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