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.

s8

 

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

s1

 

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

s2

 

Looking in the directory, it shows that the file does not exist.   Hmmm.

s4

 

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)

s7

 

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

s3_new

 

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

s5

 

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

s6

 

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.

s9

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s