Package deployment error

Question

Post reply

Package deployment error

VSSGeorge

SSCrazy Eights

Points: 8151
More actions
September 25, 2019 at 1:24 pm

#3683299

When I try to deploy SSIS package using package deployment, I am getting the error message below:
TITLE: SQL Server Integration Services
------------------------------
The SELECT permission was denied on the object 'projects', database 'SSISDB', schema 'catalog'. (Microsoft SQL Server, Error: 229)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=13.00.1601&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

But I am able to query the following in SSMS, "SELECT * FROM SSISDB.CATALOG.projects".
What is the reason for this package deployment error?

Viewing 6 posts - 1 through 5 (of 5 total)

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

Phil Parkin SSC Guru Points: 246962 More actions · Answer 1

Are you sysadmin on the instance?

Are you logged in using Windows Auth?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

VSSGeorge SSCrazy Eights Points: 8151 More actions · Answer 2

I am the Sysadmin in the instance & I am using sa login using SQL Authentication.

This login also allows me to create a folder under the SSIS catalog, a feature which is restricted to Windows Authentication.

Phil Parkin SSC Guru Points: 246962 More actions · Answer 3

I've seen plenty of issues in the past in SSIS when using SQL Authentication.

Are you able to log in with sysadmin rights using Windows authentication & try again?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

VSSGeorge SSCrazy Eights Points: 8151 More actions · Answer 4

How to set sysadmin rights for my Windows authentication ?? Kindly guide me on this.

Phil Parkin SSC Guru Points: 246962 More actions · Answer 5

Create the login:

CREATE LOGIN [domain\ntuser] FROM WINDOWS

2. Add the login to the sysadmin server role

ALTER SERVER ROLE [sysadmin] ADD MEMBER [domain\ntuser]

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin