sql server - deployment facing -
hi not able create ssis catalog in management studio?
it showing error....
the catalog backup file 'c:\program files\microsoft sql server\110\dts\binn\ssisdbbackup.bak' not accessed. make sure database file exists, , sql server service account able access it. (microsoft.sqlserver.integrationservices.common.objectmodel)
i have same issue. trying google way through it. things have noted in answers other sites:
- integration services has part of sql server install (update product , add if missing, add file)
- version of sql server management studio , sql server engine need match
- file may in wrong location, find , copy sql server looking it.
- run sql server management studio administrator avoid permissions issues
my solution was attempting create ssis db on remote server , not server logged into. once attempted on local server worked fine.
Comments
Post a Comment