Forum Discussion
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
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------