User Profile
theherbert-oneiroworks
Copper Contributor
Joined Mar 27, 2019
User Widgets
Recent Discussions
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 create an SSIS Deploy for the release pipeline, using the agent. But I am getting an error, that it cannot connect to the server. Log snippet: 2023-01-26T02:23:43.1916043Z ------------------------------ispac to deploy--------------------------------- 2023-01-26T02:23:43.1964038Z C:\azagent\_work\r1\a\[xxx]\[xxx]\[xxx].ispac 2023-01-26T02:23:43.1972341Z ------------------------------------------------------------------------------ 2023-01-26T02:23:43.2015150Z 2023-01-26T02:23:43.3927735Z ##[error]01/26/2023 02:23:43 Failed to connect to the SQL Server '[xxx]': Failed to connect to server [xxx]. 2023-01-26T02:23:43.3940302Z ##[error]01/26/2023 02:23:43 Failed to connect to server [xxx]. 2023-01-26T02:23:43.4000635Z -----------------------------------Errors------------------------------------- 2023-01-26T02:23:43.4090460Z ##[error]Failed to connect to the SQL Server '[xxx]': Failed to connect to server [xxx]. 2023-01-26T02:23:43.4097170Z 2023-01-26T02:23:43.4126075Z ##[error]Failed to connect to server [xxx]. 2023-01-26T02:23:43.4130942Z 2023-01-26T02:23:43.4846671Z ##[section]Finishing: Deploy SSIS I can see the ispac file in the server & I can run it manually, but it seems it can't when via Azure Devops. Appreciate any help... please.1.8KViews0likes2Comments
Recent Blog Articles
No content to show