Can't export projects from the Integration services Catalogs

• munchthk

  SSC Veteran

  Points: 292

  More actions

  April 20, 2017 at 2:11 pm

  #322977

  Hi guys, I am unable to extract/export projects from the Integration Services Catalogs in sql server management.
  The error I get is:
  The execute permission was denied on objet 'get_project', database 'SSIDB', schema 'catalog'.
  
  Can you please help me to figure out what can be causing this error?
  One of my work partners has the same exact profile as mine and he can export projects without any issue.

  Thanks!

• aprathour.89

  Default port

  Points: 1495

  More actions

  April 20, 2017 at 11:19 pm

  #1939233

  Seems your user id don't have access on ssis catalog. Grant  ssis_admin role to user id  on SSISDB catalog then try to perform import and export.

  -----------------
  Aditya Rathour
  SQL DBA

  Not Everything that is faced can be changed,
  but nothing can be changed until it is faced.