?
Solved

linked servers in SQL Server

Posted on 2014-04-10
7
Medium Priority
?
517 Views
Last Modified: 2014-04-16
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
Comment
Question by:pma111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 5

Accepted Solution

by:
jayakrishnabh earned 2000 total points
ID: 39991895
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
 
LVL 3

Author Comment

by:pma111
ID: 39991969
Will the above query list which account is used in the link
0
 
LVL 3

Author Comment

by:pma111
ID: 39992000
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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
LVL 3

Author Comment

by:pma111
ID: 39993580
Any views on the follow up questions?
0
 
LVL 5

Expert Comment

by:jayakrishnabh
ID: 39993684
Yes, access to remote server and vice versa is allowed. Account will not be listed in the query result.
0
 
LVL 3

Author Comment

by:pma111
ID: 39993718
So how can you tell which account is used for the link? There must be someway to tell?
0
 
LVL 5

Expert Comment

by:jayakrishnabh
ID: 39993890
Accounts used for the linked server can be found from the linkedserver properties window or create script of that
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question