SQLTeam.com | Weblogs | Forums

Linked Servers - MS SQL Server Migration from 2012 to 2017

I'm preparing migration for whole server SQL Server instance 2012 to 2017 (new project, don't know the old environment in details), but have question here only about the Linked Server.

This is the Configuration:

image

So, as you can see, I cannot see any information in GENERAL tab. BUT, when I SCRIPT the linked server (CREATE TO), I see all information, what probably I should see in GENERAL tab, part of the generated script:

EXEC master.dbo.sp_addlinkedserver @server = N'LinkeServerName', @srvproduct=N'', @provider=N'SQLNCLI', @datasrc=N'ServerSourceName', @catalog=N'db_name'

Of course I have replicated the real name of settings. So it seems it is something... but WHY I cannot see any information when I go to Properties of the Linked Server directly?

I cannot see also the whole catalog in SSMS below Linked Server...

Because of cleaning process I don't know if the Linked Server can even works...