snippetsqlMajor
Not able to create SSISDB catalog
Viewed 0 times
createssisdbcatalognotable
Problem
Getting the error below while trying to create a catalog in sql server 2014 integration services.
Any idea what I missed in installation or anywhere else?
The catalog backup file 'C:\Program Files\Microsoft SQL
Server\120\DTS\Binn\SSISDBBackup.bak' could not be accessed. Make sure
the database file exist, and the SQL Server Service account is able to
access it(Microsoft.SqlServer.IntegrationServices.Common.ObjectModel)
Any idea what I missed in installation or anywhere else?
The catalog backup file 'C:\Program Files\Microsoft SQL
Server\120\DTS\Binn\SSISDBBackup.bak' could not be accessed. Make sure
the database file exist, and the SQL Server Service account is able to
access it(Microsoft.SqlServer.IntegrationServices.Common.ObjectModel)
Solution
I had this problem and it wasn't related to user permissions.
I had done an earlier install of SQL server and chose to install many options except for 'Integration Services',
so I ran the SQL Server Installation Centre application again and this time chose to install the 'Integration Services' feature.
I think that the reason I could see the 'Integration Services Catalogs' node in SMSS despite not having installed 'Integration Services', was due to choosing to install 'Master Data Services' during my earlier SQL Server install.
I had done an earlier install of SQL server and chose to install many options except for 'Integration Services',
so I ran the SQL Server Installation Centre application again and this time chose to install the 'Integration Services' feature.
I think that the reason I could see the 'Integration Services Catalogs' node in SMSS despite not having installed 'Integration Services', was due to choosing to install 'Master Data Services' during my earlier SQL Server install.
Context
StackExchange Database Administrators Q#77247, answer score: 21
Revisions (0)
No revisions yet.