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-24T03:18:22.0917377Z ------------------------------ispac to deploy--------------------------------- 2023-01-24T03:18:22.0967049Z C:\azagent_work\r1\a[XXXX][XXXX][XXXX].ispac 2023-01-24T03:18:22.0977826Z ------------------------------------------------------------------------------ 2023-01-24T03:18:22.1047463Z 2023-01-24T03:18:22.3707323Z ##[error]01/24/2023 03:18:22 Failed to connect to the SQL Server '[XXXX]': Failed to connect to server [XXXX]. 2023-01-24T03:18:22.3720991Z ##[error]01/24/2023 03:18:22 Failed to connect to server [XXXX]. 2023-01-24T03:18:22.3769044Z -----------------------------------Errors------------------------------------- 2023-01-24T03:18:22.3820946Z ##[error]Failed to connect to the SQL Server '[XXXX]': Failed to connect to server [XXXX]. 2023-01-24T03:18:22.3823079Z 2023-01-24T03:18:22.3842653Z ##[error]Failed to connect to server [XXXX]. 2023-01-24T03:18:22.3844585Z 2023-01-24T03:18:22.4537552Z ##[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.
Add the agent name as part of the setup:
This is what the PS setup at the host server looks like:
- Designing databases and applications for hosted / cloud solutions
- How do I use SQLAlchemy create_engine() with password that includes an @
- How can I check whether a number is contained in comma separated list stored in a varchar column?
- SQL Server : Always Encrypted (Datatype clash error whe trying to insert value in an encrypted column)
- Including a distribution database in 'DatabaseBackup - USER_DATABASES - DIFF' in Ola Hallengren Script
- How do I set timezone for my docker container?
- Retrieve from 4 SQL tables with two count/group by values?
- How to SELECT year using a WHERE clause on a DateTime type column
- The data type is DT_NTEXT, which is not supported with ANSI files
- Missing artifact com.microsoft.sqlserver:sqljdbc4:jar:4.0
- Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
- How to obtain only rows with a nvarchar column containing at least one of a list of string?
- SQL Server export to Excel with OPENROWSET
- Update a date field in selected records with a calculated, relative date
- Remote certificate rejected when connecting to SQL Server from Linux host
- How to check which query or user caused SQL Server 100% CPU Utilization
- ER diagram to SQL query
- How can I correct the correlation names on this sql join?
- Query to find all members of multi level many to many relationships and also the top most member of the hierarchy
- What do the Categories in SQL Server Agent Jobs mean?
- Delphi TADOQuery exec for SQL Server stored procedure - exception not caught when multi-column unique index violated
- Get value from first row to another based on different primary key values
- Using the WITH clause in an INSERT statement
- T-SQL query very slow when using index on Date column
- Select Case Conversion failed when converting the varchar value to data type int
- Can't log into SQL server after changing computer name
- Query that groups rows based on the difference between datetime column value from a previous row?
- Add new property to nested object in all objects of JSON array with SQL
- Azure Devops SSIS Deploy, cannot connect to on prem server
- What is SQL Azure?