Answer: Could not find server 'server name' in sys.servers. SQL Server 2022

answer re: Could not find server 'server name' in sys.servers. SQL Server 2014

Feb 15 '19

48

At first check out that your linked server is in the list by this query

select name from sys.servers

If it not exists then try to add to the linked server

EXEC sp_addlinkedserver @server = 'SERVER_NAME' --or may be server ip address

After that login to that linked server by

…

Open Full Answer

I just solve my problem, by the way this is my first post on DEV.
Thanks