Apart from the usual connection string that we can use in our ProcessRobot installation which is in the below format:
Password=<password>; Persist Security Info=True; User ID=<dbUserName>; Initial Catalog=<dbName>; Data Source=<serverName\SQLEXPRESS>;
we could also use one of the below which provide different security options:
Integrated Security=SSPI; Initial Catalog=<dbName>; Data Source=<serverName\SQLEXPRESS>;
Integrated Security=true; Initial Catalog=<dbName>; Data Source=<serverName\SQLEXPRESS>;
Using one of the above, the PR Server can access the SQL database with Windows authentication. Therefore, we do not need to specify the SQL user's credentials in the connection string.
However, the PR server is not going to start because the Server's service is set by default to Log On using the Local System account. So we should change the login credentials of the PR Server's service accordingly, as shown below: