Forum Discussion

sharrock1985's avatar
sharrock1985
Copper Contributor
Nov 19, 2026

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?