SQl Server 2014 linked server remote server

Question

SQl Server 2014 linked server remote server

johnnyrmtl

Hall of Fame

Points: 3654
More actions
November 27, 2025 at 12:33 pm

#4691392
Hello all,
I have a linked server created on an instance which only has a name but it's actually pointing to a server . Where can I find this as the data source doesn't mention the actual server ... really strange. Of course properties didn`t have any server name .
thanks
- This topic was modified 2 weeks, 6 days ago by johnnyrmtl.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Mr. Brian Gale SSC-Insane Points: 24988 More actions · Answer 1

Not sure I fully understand what you are asking, but what I suspect is that you are looking at the linked server from the GUI. If so, try scripting it out. If you STILL only get the instance name without server (ie database not server\database), then it is likely using a SQL Alias and you'll need to check the registry (HKLM\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo and/or HKLM\SOFTWARE\WOW6432Node\Microsoft\MSSQLServer\Client\ConnectTo).

The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

johnnyrmtl Hall of Fame Points: 3654 More actions · Answer 2

Basically. I was just browsing this server`s linkedservers and most are created with like you mention an alias ( not sure why but this is a terrible way to do things ). I tried scripting the linked server but no clue as to where it points. Will see in the registry like you say

Thanks for the tips

This reply was modified 2 weeks, 6 days ago by johnnyrmtl.
This reply was modified 2 weeks, 6 days ago by johnnyrmtl.

Eddie Wuerch SSChampion Points: 12543 More actions · Answer 3

You can get everything from the sys.servers view.

SELECT * FROM sys.servers

Eddie Wuerch
MCM: SQL

johnnyrmtl Hall of Fame Points: 3654 More actions · Answer 4

thank you for the responses ...

I found in SQL config manager under aliases!