This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Issue : Running Groundplex as a Windows Service : SQL Server – Stored Procedure Snap Authentication

RojoLucas
New Contributor II

‎05-08-2019 02:57 AM

Issue : We can no longer use the SQL Server - Stored Procedure Snap when running a Groundplex as a Windows Service.

Scenario : We have configured a pipeline which retrieves information from an on premise database via the SQL Server - Stored Procedure snap using a system account. The pipeline is working fine if we do not run the groundplex as a service. If we run the same integration on a Groundplex which is installed as a service the connection to the stored procedure can no longer be realized.

SL-Issue08052019

0 Kudos
1 REPLY 1

ForbinCSD
Contributor

‎07-23-2019 09:58 AM

Are you using Windows Authentication, or native SQL Server authentication?

If you are using Windows Authentication, do you have “LocalSystem” added in your SQL Server instance as an authorized user?

The windows service for the Groundplex runs as this user, and if you were previously using your working login and Windows Authentication, it won’t work.

You’ll need to either add the credentials to the SQL Server instance, or else you’ll need to switch to native SQL authentication on your server, set up an account in the instance, and then configure the Snap’s account object to use the new credentials. I recommend the latter method, as it gives you more visibly direct control of how you are logging into SQL Server.

0 Kudos