Forum Discussion
Azure Devops SSIS Deploy, cannot connect to on prem server
I have an SSIS project that I want to use Azure DevOps' CI/CD. Using SSIS build for the build pipeline, it works. I have created an agent, installed and configured in the desired on-prem server. I c...
theherbert-oneiroworks You need to check what permissions the Azure DevOps self-hosted agent service has and what account is executing the service. That account will need to have permissions to log into your SQL Server.
I'm guessing you're running the agent service using the NETWORK SERVICE credentials which probably won't work.