SSISDBBackup.bak could not be accessed

If you try and create an Integration Services Catalog and you receive the error SSISDBBackup.bak could not be accessed, it could be because you do not have Integration Services installed on your SQL Server instance.

Below I am going to attempt and create an Integration Services Catalog, by right clicking the item within SSMS and choosing Create Catalog.

You can read more about the benefits of using a catalog by following the link below:  https://docs.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-2017.  If you are going to run/manage many SSIS packages, using a catalog makes life a lot easier.

It then prompts you with some options, I choose the items below.

When you press OK, but then you’ll get the error below.  It could not find the backup file to restore and create the catalog.

To fix this error, you need to make sure that you install Integration Services for this instance.  Start up the installer and select the add features to an existing installation (highlighted in yellow below)

Now select Integration Services from the options below and press Next.

It should install without issues, but you will need to reboot after installing.

After rebooting, you can look in the directory and see that the SSISDBBackup.bak file is now located in the directory.

Now you can go through the process of creating the catalog and not receive the missing file error.  When it is installed, it will look like the screenshot below.  You can now deploy your SSIS projects and packages to the Catalog.

Read more about SSIS Catalog at bit.ly/3ktfVVj

Leave a Reply

Your email address will not be published. Required fields are marked *