December 29, 2014 at 9:46 am
I want to post a resolution to a problem that I was having that appeared to be permission related. One day all of a sudden all of the ssis packages started to fail with the message in the job activity log:
Message
Executed as user: ***. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5058.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 11:03:36 AM Failed to execute IS server package because of error 0x80131904. Server: ., Package path: *****.dtsx, Environment reference Id: NULL. Description: The SELECT permission was denied on the object 'catalog_properties', database 'SSISDB', schema 'catalog'. The Integration Services server property, 'ENCRYPTION_ALGORITHM', cannot be found. Check the name of the property and try again. Source: .Net SqlClient Data Provider Started: 11:03:36 AM Finished: 11:03:36 AM Elapsed: 0.11 seconds. The package execution failed. The step failed.
After many hours searching the web and trying to figure out how I all of a sudden lost permissions as well as everyone else I noticed that somehow the 'Catalog' schema owner got changed to a user. After changing the schema owner to dbo the packages were now completing. This also resolved the issue where I could not deploy packages as well as configure environments.
September 21, 2016 at 9:59 am
Thanks happened to me as well trying to connect sql2008r2 user to integration services he became owner of catalog schema Your tip saved me a lot of time trying to find why SSIS jobs were not running:-)
June 18, 2019 at 4:56 pm
Thank you this did the trick for us also!
Scott
December 15, 2022 at 12:17 am
I have faced the same issue.
I have changed catalog schema db owner to dbo, after that SSIS jobs are running.
December 15, 2022 at 2:11 am
This was removed by the editor as SPAM
January 26, 2023 at 9:10 pm
You just saved me also. Thanks for this post.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply