CODEWITHSUNDEEP
sql-serverselectssissql-server-2014sql-agent-job
Michael
Michael

Reputation: 2657

The SELECT permission was denied on the object 'executions', database 'SSISDB', schema 'internal'

I'm using SQL Server 2014 SP2. I have a SSIS Package that executes 100% interactively via Visual Studio.

When I deploy to the SSIS Catalog and schedule via a SQL Agent Job I receive the below message.

The SQL Agent Account is being executed via a Proxy Account which in turn is a Role Member of the SSIS_Admin Role.

The SELECT permission was denied on the object 'executions', database 'SSISDB', schema 'internal'

I'm assuming this is permissions? How do I resolve or where should I at least be looking?

Upvotes: 1

Views: 2458

Answers (2)

Nidhin HS
Nidhin HS

Reputation: 26

Set dbo as the owner of internal schema. This fixed the issue for me.

Upvotes: 0

Mehmet
Mehmet

Reputation: 1535

are you running the package with SQL Agent Service Account? If yes, service account should have permissions on SSISDB. you can check it here:

enter image description here

If you have created a proxy and run the package with it, that user in the proxy should have permissions in SSISDB. You can check if the proxy account exists here:

enter image description here

Upvotes: 1

Related Questions