Friday, December 14, 2012

SSIS Catalog Creation - C:\Program Files\Microsoft SQL Server\110\DTS\Binn\SSISDBBackup.bak Missing

The error below happens on SQL Server 2012 install without SSIS installed on the same host.

The catalog backup file 'C:\Program Files\Microsoft SQL Server\110\DTS\Binn\SSISDBBackup.bak' could not be accessed. Make sure the database file exists, and the SQL Server service account is able to access it.

This will be the case for most installs on clusters since its not recommended.

http://technet.microsoft.com/en-us/library/hh213127.aspx

To fix this issue copy that file from a SSIS install to the same directory. Rerun your SSIS Catalog create dialog. If this isn’t your issue you may want to check on this connect issue post.

https://connect.microsoft.com/SQLServer/feedback/details/620992/create-catalog-integration-services-fails-if-the-default-backup-location-was-changed-during-install

 

No comments: