Share via

Creating a SSIS catalog on an Azure VM (IaaS)

pmscorca 882 Reputation points
2020-12-03T17:53:04.197+00:00

Hi,
I'm trying to create a SSIS catalog on an Azure VM with SQL Server 2016 (standard edition) and SSMS v18.4, unsuccessfully. It is a IaaS scenario.
I cannot create the catalog without creating an IR on Azure. I'd like to accomplish a such task as it occurs for a SQL Server installation on-premise.

How could I solve this issue, please?

44931-image.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. pmscorca 882 Reputation points
    2020-12-03T18:49:42.257+00:00

    Hi,
    I've solved using a PowerShell script.

    Bye

    1 person found this answer helpful.
    0 comments
  2. Monalv-MSFT 5,896 Reputation points
    2020-12-04T06:00:12.13+00:00

    Hi @pmscorca ,

    Please accept the answer which is helpful for you to solve the question.

    We can also create SSIS catalog (SSISDB) hosted by Azure SQL Database server.

    Please refer to Creating SSISDB in Azure SQL Database.

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues in November--What can I do if my transaction log is full?
    Hot issues in November--How to convert Profiler trace into a SQL Server table?

    0 comments