Hi,
I have a problem here that is related to both Jira Rest API, and SQL server.
I have an SSIS package to consume REST API GET request to extract Jira data into our SQL server.
I used basic authentication (username/password) in the HTTP connection manager for Jira authentication. The SSIS package works fine on my local machine using Visual Studio 2017. But when the SSIS job is ran on SQL server, the job fails. I keep getting a 403 Forbidden error message, please see attached error message from SQL server. From what I understand, it looks like the SQL server does not have permission to access Jira REST API.
Can anybody please give me some ideas of how to resolve this? I think the Jira admin would have to grant permission to the SQL server. But I am not sure if permission should be granted to the SQL server machine, or the service account that I use to log on to SQL server. FYI our Jira is on-prem, and the SSIS package is ran under an proxy account if you have experience in using SQL server agent to schedule SSIS jobs.
Thanks and much appreicated for any suggestions.
It turns out that our Jira is OKTA authenticated. The Jira admin created a service account to bypass OKTA and it worked!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.