SSIS Catalog – Path to backup file could not be determined | Under the kover of business intelligence

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

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:

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:

@SQLSoldier No, couldn’t connect. Which rang a bell – I was using SSMS 2012 :). SSMS 2014 did the trick. Thanks. #sqlhelp

— Blaž Dakskobler (@blazdax) April 7, 2014

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.

One thought to “SSIS Catalog – Path to backup file could not be determined”