• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 523
  • Last Modified:

linked servers in SQL Server

In a SQL server, where can you see what linked servers are configured, and under which account? For what reasons do people set up linked servers, and what are the risks associated with setting up a linked server via an account with high permissions? Is there a SQL Server that can query linked server settings?
0
pma111
Asked:
pma111
  • 4
  • 3
1 Solution
 
jayakrishnabhCommented:
Find the available linked servers under "Server Objects -> Linked Servers"
Linked servers are generally used to get the data from different server tables just like querying from different database of same server. If high permissions are given, delete or update of other database data is possible.

Query to find linked servers :
SELECT * FROM sys.servers WHERE is_linked = 1
0
 
pma111Author Commented:
Will the above query list which account is used in the link
0
 
pma111Author Commented:
And are these links those which allow our users to access a remote server or vice versa allows remote users to access our server
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
pma111Author Commented:
Any views on the follow up questions?
0
 
jayakrishnabhCommented:
Yes, access to remote server and vice versa is allowed. Account will not be listed in the query result.
0
 
pma111Author Commented:
So how can you tell which account is used for the link? There must be someway to tell?
0
 
jayakrishnabhCommented:
Accounts used for the linked server can be found from the linkedserver properties window or create script of that
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now