Issue connecting to SQL in NCrunch test nodes

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

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.

Awesome! that worked. Thanks Remco.