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.

Answer 1

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

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

for more info about changing the server name