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

[hamtaro^-^]

Any idea what is the cause and how to solve this issue?
By the way I am using a linked Server

SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
OLE DB provider "SQLNCLI" for linked server "VCDB" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "VCDB" returned message "An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".


Thanks
-Hamtaro

[GaryMazzone]

How many dots (.) in the linked server name? It might be the way the link name is formated

[hamtaro^-^]

I'm sorry, what do you mean dots(.), Where can i find it so that i can provide the information you needed?

Thanks

[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