September 10, 2013 at 2:11 am
Hello,
I think that the answer is 'no', but does anyone know of a way to identify linked servers which connect to a particular instance from that instance?
I wish to change a login password on my instance and think that there are other instances on my LAN which have linked server connections to mine using this login and if I change the password they will fail. If I can identify them ahead of my change then I can take action to stop them failing (put in an alias). I wasn't sure if there was a log or metadata to record connections which I could query to gain this knowledge.
I think it may be possible to use Registered Servers and run a common query over all the instances I already know about, but I neither know the syntax for this type of query nor do I know all the instances on my LAN.
Failing any prior testing I'll have to resort to making the change and picking up any failures as they occur, but that doesn't seem very professional.
Any thoughts?
September 10, 2013 at 3:34 am
Hope ur asking about sqlserver related linked servers which
we can find by using sp_linkedservers stored procedure
or if u expand server objects u can see the linked servers
in sqlsever management studio[ssms]
or else you can search for the scripts to get the details jz google for the script which u want!
Thanks
Naga.Rohitkumar
September 10, 2013 at 4:34 am
Yep, most definitely SQL Server Linked Servers.
sp_linkedServers only shows me the servers linked from this instance, what i'd like to know are servers linked to this instance.
September 10, 2013 at 4:39 am
wheter those servers are sqlserver or any other ?
1. if those are connected from odbc and jdbc u can find in linked servers
2. if they are connected to DNS check by scripts or in network servers if any other connection are shared for the server instance to connect those
3. or any application or db realted jobs or batch files connected to current instance from other instance
Thanks
Naga.Rohitkumar
September 10, 2013 at 4:50 am
I'm not sure I understand your response.
If I have two SQL instances on different servers (InstanceA and InstanceB). I know, because I've looked, that InstanceB has a Linked Server configured to look at InstanceA, but how can I tell this by only looking at InstanceA?
The reason for this limitation is that I know that in the real world I have many instances and I don't want to have to check each one in turn for linked servers.
Does this additional information help in defining my problem?
September 10, 2013 at 5:12 am
for that purpose it self i have suggested to google then u can find some scripts test those in t&d server or in local pc where sql server is running and see the out put then u will get an idea for which u r loooking
Thanks
Naga.Rohitkumar
September 10, 2013 at 5:17 am
I think that you're suggesting that I Google my problem. I've tried that and have been unsuccessful, hence my post here. Perhaps my Google powers are weak today and I'm searching for the wrong text. Can you suggest what text I should be searching for?
September 10, 2013 at 7:47 am
as far as I know, there is no way of telling the connection actually comes from a linked server definition.
What you can do is do some connection tracking and see what that gives you.
I've attached a sql script we use to monitor our connections via xEvents.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply