SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

[GaryMazzone]

Look in the linked server name dome thing like Nebisco.com.VEQS122\DB1.Mission.Someone.Table

[hamtaro^-^]

Ok, btw what i did is first i add a linked server in TestServerA and TestServerB

--@TestServerA
if exists (select name from sys.servers where name = 'VCDB' and is_linked = 1)
EXEC sp_dropserver 
 @server = 'VCDB',
 @droplogins = 'droplogins';
EXEC sp_addlinkedserver
 @server = 'VCDB',
 @srvproduct='',
 @provider = 'SQLNCLI',
 @datasrc = 'TestServerB\InstanceName',
 @catalog = 'sampleDatabase';
exec sp_addlinkedsrvlogin 'VCDB', 'false', NULL, 'Admin', '1234';
exec sp_serveroption @server='VCDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='VCDB', @optname='rpc out', @optvalue='true';

---@TestServerB

if exists (select name from sys.servers where name = 'ACDB' and is_linked = 1)
EXEC sp_dropserver 
 @server = 'ACDB',
 @droplogins = 'droplogins';
EXEC sp_addlinkedserver
 @server = 'ACDB',
 @srvproduct='',
 @provider = 'SQLNCLI',
 @datasrc = 'TestServerA/instacename',
 @catalog = 'sampledatabase2';
exec sp_addlinkedsrvlogin 'ACDB', 'false', NULL, 'admin', '1234';
exec sp_serveroption @server='ACDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='ACDB', @optname='rpc out', @optvalue='true';

This is how i linked my two database

and still i got an error

Hope it will help this information to you
Thanks