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

Popular posts from this blog

Combining PHP Registration and Login into one class with multiple functions in one PHP file -

Android volley - avoid multiple requests of the same kind to the server? -

magento2 - Magento 2 admin grid add filter to collection -