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

magento2 - Magento 2 admin grid add filter to collection -

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

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