Linked server with same server name

Question

I'm creating a linked server, to another one that have the same server name with the local the server "HP-PC".

So when entering the name of the linked server, I have this error message : "You cannot create a local SQL Server as Linked server". Because it is the same server name, it refers to the local one, so how can I refer to the second ?

Hope someone can help.

Can you dod it by FQDN or IP? I'm not sure why you'd have to machines on the same domain with the same name - sounds like a network config error. — Brian Riley, Feb 22 '16 at 18:06
I just set "HP-PC" as name of linked server. I didn't specify the FQDN. Is there a way to do it for linked server ? — Lion_CH, Feb 22 '16 at 18:09
not sure I understand the question - please list the FQDN of the 2 machines. — Brian Riley, Feb 22 '16 at 18:14

score 0 · Answer 1 · answered Feb 22 '16 at 18:45

0

I solved it by changing the computer name, then changing the server name :

sp_dropserver 'HP-PC'
sp_addserver 'NEW_SERVER_NAME'
SELECT * from sys.sysservers
the new server name must appear

for more info about changing the server name

answered Feb 22 '16 at 18:45

Lion_CH

78
2
8

Linked server with same server name

1 Answers1