Can't Create A Ssisdb Catalog Due To Missing Ssisdbbackup.bak File, Even Though Ssis Is Installed

I've downloaded SQL Server 2016 standard edition trial along with SSDT in order to test what one can do with a standard edition in SSIS, SSRS, and SSAS. I also wanted to know whet

Solution 1:

To check if SSIS installed, open Sql Server Configuration Manager, in the SQL Server Services, is something like 'SQL Server Integration Services 13.0' running?

Solution 2:

I faced with this error when I used lower version of SSMS than SSIS. Check if you use proper version of SQL Management Studio.

Solution 3:

Experienced this error message on MS SQL Server 2017.

Resolved by launching MS SQL Server 2017 install media, added Integration Services feature.

After successful installation, when back into SSMS, right-click on Integration Services Catalog for Create Catalog... option.

You will be asked for an encryption password to create the new SSISDB.

Hope this helps!