Forum Discussion

johnbilay's avatar
johnbilay
New Contributor II
7 years ago

Issue with SQL connection with groundplex running as service

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
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)

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?

Kr
J

1 Reply

  • robin's avatar
    robin
    Former Employee
    4 years ago

    Yes, though I would consider it “XHTML” (an old term)

    • darshthakkar's avatar
      darshthakkar
      Valued Contributor
      4 years ago

      Thanks @robin, I haven’t had a chance to test the solution you provided but I’m sure it would have worked.
      I went with a different route for my development so the concern I was having has been resolved.

      XML Generator does intake dynamic values if they have been binded properly prior to it (using Aggregate or Group By), the only challenge I found was ingesting native html tags because <a href ="$URL"> wasn’t generating the desired output as the tags gets converted to snapLogic’s predefined symbols like < = &lt;,so on and so forth. Check these links for detailed explanation on tags conversion:

      Link 1
      Link 2

      What I found and worked for me was defining the html format (if you’re trying to generate html files; could be any format you’re interested into) in the mapper itself/file writer and then let the format do its job.

      Thanking @robin for his suggestions, time and help on this. Signing off from this thread.