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.

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.


Get event action failed. The required certificate doesn't exist in the key store.

This error comes if your event subscription username and password aren’t filled in. You may see this error if right click on the IPS in IME and click status. The connection status should read OK. Update your IPS by right clicking and click edit and fill in both subscription username and passwords fields. Hope this will help ya solve this problem since it doesn’t seem to have anything to do with a certificate.