Hall of Fame
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:
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.
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:-)
Thank you this did the trick for us also!
I have faced the same issue.
I have changed catalog schema db owner to dbo, after that SSIS jobs are running.
This was removed by the editor as SPAM
You just saved me also. Thanks for this post.
Viewing 6 posts - 1 through 5 (of 5 total)