SSISDB. "Create Catalog" Option in SQL Server 2019 Developper. Button "OK" missing.

Jorge Novizki 21 Reputation points
2020-09-10T18:26:18.557+00:00

I got installed MS SQL Server 2019 Developper edition (version 15.2002.4709.1) in my Windows 10 Home Edition. I selected the option "Integration Services" among others.
I started the corresponding instance of the Developper from the SQL Management Studio v 18.2. (I have a previously installed MS SQL Server 2017 Express)
I logged in to the SQL Server with a Windows Autentication Login with sysadmin privileges.
I clicked the node "Integration Services Catalog" and selected the Option: "Create Catalog".

The "Catalog Creation Wizard" Dialog does not show the "OK" Button.

(I don't want to use the button "Create SSIS IR", required for Azure features)

Therefore I can not continue with the desired option.

I runned a Maintenance process from the SQL Installation Center and got a Report indicating that Integration Services were correctly installed.
I also checked that the backup Database SSISDBBackup.bak was correctly deployed in the corresponding directory by the setup process.

Could you please, check if this is a user error or a probable bug?
I would appreciate your comments.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 26,586 Reputation points
    2020-09-10T21:18:49.457+00:00

    It seems that some folks are experiencing the same issue like you due to SSMS having some high-DPI rendering issues.

    Check it out here: cannot-create-integration-services-catalog-without-azure-subscription


1 additional answer

Sort by: Most helpful
  1. Monalv-MSFT 5,926 Reputation points
    2020-09-11T01:56:18.413+00:00

    Hi @Jorge Novizki ,

    4.Click Enable CLR Integration.
    The catalog uses CLR stored procedures.
    5.Click Enable automatic execution of Integration Services stored procedure at SQL Server startup to
    //This step is optional.
    enable the catalog.startup stored procedure to run each time the SSIS server instance is restarted.

    Hope the following links will be helpful:

    To create the SSISDB catalog in SQL Server Management Studio

    Create SSIS Catalog

    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.

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.