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!

Are you logging in locally? If so, have you selected "With profile"?

---

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

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.

---

The execute task has with Profile option, the Execuet script doesn't, just a dropdown for credentials.

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.

---

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:

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

NP. Glad you sorted it out 🙂

---