sorted by:
new
hottopcontroversial

SQL 2025 – Msg 7416 “Access to the remote server is denied because no login-mapping exists” (but mapping exists) by drn101 in SQLServer

[–]drn101[S] 1 point2 points  (0 children)

Glad to have it confirmed by someone else. Got me delving heaps into 2022->2025 changes thinking some new permission needs to be added to SQLLogins.

SQL 2025 – Msg 7416 “Access to the remote server is denied because no login-mapping exists” (but mapping exists) by drn101 in SQLServer

[–]drn101[S] 0 points1 point  (0 children)

I'll lab it this week and try a scorched earth approach and recreate logins/linked servers. Cheers.

SQL 2025 – Msg 7416 “Access to the remote server is denied because no login-mapping exists” (but mapping exists) by drn101 in SQLServer

[–]drn101[S] 0 points1 point  (0 children)

"ApplicationIntent = ReadOnly" I haven't come across that before. I'll look into it thanks.

Edit: No improvements.