Forum Discussion
SQL Server 2022 CU28 - Linked Server Msg 7225
Immediately after applying CU28, our SSIS packages started failing with:
Msg 7225, Level 16, State 1
The current user does not have permission to execute queries against linked server 'LINKEDSERVER01'.
The linked server uses a fixed remote login, no changes were made to the linked server, SSIS package, service account, or permissions.
I've reproduced it outside SSIS with:
EXECUTE AS LOGIN = 'DOMAIN\ServiceAccount$';
SELECT TOP 1 *
FROM [LINKEDSERVER01].[DatabaseName].dbo.SomeTable;
REVERT;
When the service account is sysadmin, the query succeeds.
When sysadmin is removed, the same query fails with Msg 7225.
The linked server has a catch-all login mapping (local_principal_id = 0, uses_self_credential = 0) and explicit mappings do not resolve the issue.
The only change in the environment was the upgrade to SQL Server 2022 CU28.
Has anyone else seen a change in linked server permission behaviour after CU28, particularly with EXECUTE AS LOGIN and non-sysadmin service accounts?