Executed as user: uk\Login. Microsoft (R) SQL Server Execute Package Utility Version 13.0.5820.21 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 15:20:42 Failed to execute IS server package because of error 0x80131904. Server: aznu-p-ltnr-001,1433, Package path: Environment reference Id: NULL. Description: The database owner SID recorded in the master database differs from the database owner SID recorded in database 'SSISDB'. You should correct this situation by resetting the owner of database 'SSISDB' using the ALTER AUTHORIZATION statement. Source: .Net SqlClient Data Provider Started: 15:20:42 Finished: 15:20:42 Elapsed: 0.625 seconds. The package execution failed. The step failed.
Then you need to check SSISDB Owner and if the Owner of the DB is different than SA then you need to change it to SA, if still the issue is not resolved then you need to enable the trustworthy property of SSISDB. please find the below.
to resolve it try the following :-
Alter AUTHORIZATION ON DATABASE ::[SSISDB] TO SA;
Alter DATABASE [SSISDB] Set TRUSTWORTHY ON;
No comments:
Post a Comment