Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


victoria
2009-05-08T22:05:58Z
Hi,all!

I have a problem trying to connect to my SQL server using credentials in my task.

I have an execute I need to run. This execute has a config file that contains a connection string that uses Integrated Security. Basically, that execute will have to run under an specific NT user to be able to connect to the database.

I went ahead and created a new credential entry. If I create a task that runs the execute using that credential, the process will work with no problem.

However, I need to use a VBScript file to feed my arguments dynamically. So I went ahead and created an Execute Script task that points to my VBSript file. In the credentials drop down I select the same credentials I used for the previous task that is working. The task runs, but now I get a Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' error in my event log.

Could someone explain what I am missing? I do not see any extra settings in the Execute Script tab but the selection of the file and the credential dropdown.

Thanks!
Sponsor
Forum information
Support
2009-05-09T00:16:05Z
Are you logging in locally? If so, have you selected "With profile"?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
victoria
2009-05-11T14:49:48Z
Yes, I am locally logged in because I am still developing and testing. But it won't be the case once it is in the QA server. Then it will be running under a scheduler. Also, I don't understand what you mean with select "Whith Profile". Is this a setting in VC I have overlooked?

Thanks!

V
Support
2009-05-11T14:54:06Z
OK, I think you misunderstood. I am talking about the Execute settings. The Credential that you use and "With profile" option in the Execute settings.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
victoria
2009-05-11T15:07:35Z
The execute task has with Profile option, the Execuet script doesn't, just a dropdown for credentials.
Support
2009-05-11T15:26:36Z
Ok, try to change to a Execute Task instead. And point to the the full path to the cscript.exe in command line and full path to your script in the argument. Then use Credentials with Profile option.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
victoria
2009-05-11T17:13:21Z
It did not work. I guess the argument box is expecting real arguments and not a path to a vbs file. I am sending the error I got in the event log below:


*** Exception Level 1 ***************************************
ExceptionType: FormatException
HelpLine:
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at System.Convert.ToInt32(String value)
at BroadcastCacheUpdater.Program.Main(String[] args) in C:\Advanced Services\Working\Broadcast\BroadcastSidebar 1.0\BroadcastCacheUpdater\Program.cs:line 28
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)
Data:
victoria
2009-05-11T20:03:29Z
I think I figured out the problem. The fact that the vbs file is running under credentials doesn't the execute runs under the same one. I feel a little embarrast I didn't think about this. It seems quite obvious.

Thanks for your fast response.

V
Support
2009-05-11T20:09:15Z
NP. Glad you sorted it out 🙂
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top