Post reply

Issue in Deploying ssis packages to a folder in Integration Services Catalog

  • May 24, 2016 at 3:54 pm

    #326605

    I am getting the below mentioned error message.

    The Select Permission was denied on the Object 'projects',database 'SSISDB',schema 'catalog'. (Microsoft SQL Server ,Error :229).

    I had given ssis permissions to deploy the SSIS package, i have database owner, ssis_Admin role, sysadmin permissions also. I don't see any db_denydatareader or db_denydatawriter roles also . I don't see any denied permissions .

    Can anyone give suggestions.

    Environment:

    Microsoft SQL Server 2014 - 12.0.4213.0 (X64) Jun 9 2015 12:06:16

    Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

    Windows Server 2012 R2 Datacenter 64 bit edition

  • May 24, 2016 at 3:57 pm

    #1881223

    I had given select permissions on Object 'projects',database 'SSISDB',schema 'catalog' . But that did not help either

  • May 28, 2016 at 2:25 am

    #1881908

    The issues is in the schema. I was able to find it and fix it.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply