Categories: SQL ServerSSIS

SSIS Catalog – Path to backup file could not be determined

I was creating an SSIS catalog at a new project, but I was greeted with the following error message when I hit OK:

catalog_errorcatalog_error

The path to the catalog backup file could not be determined. Integration Services might not be installed on this server, or the user may not have the appropriate access permissions.

My initial reaction was something like this:

bollocksbollocks

Why? Because I was sure SSIS was installed and I am an admin on the machine. A typical case of “the error has nothing to do with the issue, whatsoever”. Luckily I came across this Twitter conversation while googling for the error:

And lo and behold, I was indeed using the wrong version of SQL Server Management Studio. Whoops. I quickly switched to SSMS 2014 and indeed, the issue went away.


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

View Comments

Recent Posts

Book Review – Agile Data Warehouse Design

I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…

3 weeks ago

Cloudbrew 2024 – Slides

You can find the slides for the session Building the €100 data warehouse with the…

4 weeks ago

Book Review – Microsoft Power BI Performance Best Practices

I was asked to do a review of the book Microsoft Power BI Performance Best…

2 months ago

Create a Numbers Table in Power Query

This is a quick blog post, mainly so I have the code available if I…

2 months ago

Microsoft finally adds Tenant Switcher for Fabric / Power BI

Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…

2 months ago

Book Review – Humanizing Data Strategy by Tiankai Feng

This book was making its rounds on social media, and the concept seems interesting enough…

2 months ago