Scheduled Task hangs when not logged into Windows 2003 Server

[sweetiek08]

I am trying to run Microsoft Excel macros in a scheduled task on a Windows 2003 server. When I let the scheduled tasks run when I am logged in, they work. However, when I am not logged in, the task starts, but doesn't run (it displays "running" as the status, but nothing happens.) I have read that this can happen when network drives are not accessible, but I map the network drive I need in my VBA code:

Set WshNetwork = CreateObject("WScript.Network")
Set AllDrives = WshNetwork.EnumNetworkDrives()

AlreadyConnected = False
For i = 0 To AllDrives.Count - 1 Step 2
If AllDrives.Item(i) = "Y:" Then AlreadyConnected = True
Next

If AlreadyConnected = "False" Then
WshNetwork.MapNetworkDrive "Y:", "\\myserver\myshare"
End If


Any help is much appreciated!



Thank you for your help!

 

[theravager]

you have no credentials to map the drive as no one is logged in.

Either use a account in the mapping or trying adding the computer to a group with access to the server.

 

[sweetiek08]

Thank you for your response. What is the best way to include account information in the mapping? Specifically I am concerned about password security.

 

[TweakMYbox]

Go to the properties of the task, and it's right there on the first page. The stronger the password, the better.

That's about all you can do with drive mapping security on your client.

Mike Fegan

http://www.tweakmybox.com

Learn how to tweak YOUR box, and talk shop with other techies!

 

[sweetiek08]

Thanks, I have had the password set on the scheduled task, but it has not been working. I thought using the account in the mapping meant I had to specify it somewhere else. The password and user the account is set up for is an administrator on the server, and has access to drives, but it is still not working when I'm not logged in.