I have a question regarding the service account under which web node runs and how to change it.
We are setting up enterprise setup for Microsoft R Server and having multiple web nodes, we want to use a dedicated SQL Server Database using Windows Authentication. Currently when I check the PID of web node it shows that dotnet.exe is running under NETWORK
SERVICE account. As per company policies we can not give SQL access to NETWORK SERVICE account.
We want to make the changes in the account under which Web Node runs so that we can use an account which will have SQL access so that Windows Authentication can work using that account while connecting to SQL.