Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Issue connecting to SQL in NCrunch test nodes
sheryl
#1 Posted : Friday, March 11, 2016 10:43:14 PM(UTC)
Rank: Member

Groups: Registered
Joined: 5/15/2015(UTC)
Posts: 18
Location: United States of America

Thanks: 12 times
Was thanked: 3 time(s) in 3 post(s)
Hi Remco- We have Automated test cases run in distributed mode in different NCrunch grid nodes. But when it comes connecting to SQL , get login failed error, though the user has access to data base. On troubleshooting , realized that NCrunch runs the tests in Grid nodes under user: NT AUTHORITY\SYSTEM.

Now how can I override this user used by NCrunch to run tests in test node, and it to run under a user who has access to SQl? (While connecting to SQL, we want to use windows authentication instead of SQL connection for security reasons)

Thanks,
Sheryl
Remco
#2 Posted : Saturday, March 12, 2016 4:19:30 AM(UTC)
Rank: NCrunch Developer

Groups: Administrators
Joined: 4/16/2011(UTC)
Posts: 5,133

Thanks: 679 times
Was thanked: 818 time(s) in 778 post(s)
Hi Sheryl,

Thanks for sharing this issue.

When running as a service (which is the default setup), the NCrunch Grid Node will usually run as the system user. Because the test task hosts all assume the identity of the grid node itself, they will naturally run under the same user. The easiest way to change this is by finding the 'NCrunch Grid node Service' in your Windows service control manager, and changing the 'Log on as' option to an account that has access to your database server. Ensure this account also has read/write access to the grid node's install path, its snapshot storage area and its workspace base path.
1 user thanked Remco for this useful post.
sheryl on 3/14/2016(UTC)
sheryl
#3 Posted : Monday, March 14, 2016 5:18:33 PM(UTC)
Rank: Member

Groups: Registered
Joined: 5/15/2015(UTC)
Posts: 18
Location: United States of America

Thanks: 12 times
Was thanked: 3 time(s) in 3 post(s)
Awesome! that worked. Thanks Remco.
1 user thanked sheryl for this useful post.
Remco on 3/14/2016(UTC)
Users browsing this topic
Guest (2)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAF | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.027 seconds.