Dear community and expert
We have the following scenario:
Snaplogic connects to a Store procedure provided by MSQL. The authentication method used by the MSQL server is “Windows authentication”. We have a groundplex running at a Windows based VMware close to the Database.
In the account used to connect to the store procedure we are therefore using the setting “IntegratedSecurity” set to true. This works perfectly fine when the groundplex was manually started using the jcc.bat start command.
When we start the groundplex as a service using the command : jcc.bat intall_service; then the account to connect to the database does not run anymore. It fails with the error below:
SQL Server - SP_o2c_creditmgmntparent[2940ff56-c8cd-45ea-a447-18bae4652be7 – 3ea9df9e-cd6d-4804-9354-5cc0d95230db]
com.snaplogic.snap.api.SnapDataException: Failed to retrieve a database connection.
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ‘xxxxxx$’. ClientConnectionId:8cd46738-696f-4279-b460-7e3b40ebed41
I understand the reason. This is because when starting the groundplex as a service, it runs under a local user (on the Windows VMware) but not as a windows users – which is required for calling the store procedure (Since the authentication in MSQL is set to Windows…. ). Actually, we will need to run snaplogic as a service using a windows user that is authorized to connect to the MS SQL. But when I try to change the credentials of the user running the groundplex as below, the groundplex does not start. It stops immediately. Any suggestions of what to look?