Authentication using SQL server VBO

[Dawid.Pekala]

hi! Question is around accessing SQL server using VBO object. All access to SQL DBs in our company is controlled using AD Groups. I am in the same group as our test robot for test SQL and production robots for live SQL. Within my Dev environment, when I run the process in debug mode it works fine, but when I run the very same process from control room (using the machine I am logged on!) the connection fails, the error given is: "Login failed for user ." So it looks like when you I run it from control room it's the machine that runs it, not the currently logged in user. We have set up our production VMs and robot profiles in the same way. We added robots to an AD group, which has access to the live SQL DB. However looking at the message I am kind of expecting that as soon as we try to run it we will get the same problem. Question then: When - from Control Room - instructing a resource to run a process, is this resource using the robot permissions or the VM permissions when trying to connect? I hope I make sense here. Regards D

[John__Carter]

Hi Dawid - are the machines connected via BP Server or directly to SQL? The recommendation is to avoid direct connections so that you only have to worry about the Application Server connection/user/security.

[Dawid.Pekala]

hi John, I am not sure if I get your question right. BP has it's own APP server. However within the process we are connecting to different SQL DB. On a sparate note though - it looks like something has been updated @ infrastructure side since the OP, as the program is now reading (I have no idea tho if it's because it's me connecting to it, or if the machine has been granted read permisson).. Thanks for the tip though Regards