Forum Discussion

kevinfr820's avatar
kevinfr820
Copper Contributor
Aug 12, 2025

link server error after switching from SQL authentication to Active directory service account

Hi All,

 

I am trying to switch from using a SQL account to use active directory service acccount selecting impersonate option on a link server. When i try do this i get below errror.

any ideas how to fix?

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

TITLE: Microsoft SQL Server Management Studio
------------------------------

The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Access to the remote server is denied because no login-mapping exists. (Microsoft SQL Server, Error: 7416)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-7416-database-engine-error

------------------------------
BUTTONS:

&Yes
&No
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

No RepliesBe the first to reply

Resources