Click here to Skip to main content
Click here to Skip to main content

SQL Server - How to create LinkedServer using SMO

By , 13 Nov 2010
 
LinkedServer allows you to access resources in the other resources. Consider, you have a server named "ServerA" and you would like to grab some data from the remote server named "ServerB". In that case, you need to create a linked server. In our scenario, the linked server is "ServerB".
 
The linked servers communicate using an OLE DB connection. These connections handle the commands between the linked servers, so coders and administrators can query data and tables without knowing the intricacies of database communication.
 
Here is the code example that shows how to create LinkedServer using SMO:
 
Server srv = new Server(@"INSTANCEA");
LinkedServer lsrv = new LinkedServer(srv, "INSTANCEB"); 
LinkedServerLogin login = new LinkedServerLogin();
login.Parent = lsrv;
login.Name = "LOGIN_ON_INSTANCEA";
login.RemoteUser = "LOGIN_ON_INSTANCEB";
login.SetRemotePassword("PASSWORD");
login.Impersonate = false;
lsrv.ProductName = "SQL Server";
lsrv.Create();
login.Create();

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Kanasz Robert
Architect The Staffing Edge & Marwin Cassovia Soft
Slovakia Slovakia
Member
My name is Robert Kanasz and I have been working with ASP.NET, WinForms and C# for several years.
 
MCTS - .NET Framework 3.5, ASP.NET Applications
- SQL Server 2008, Database Development
- SQL Server 2008, Implementation and Maintenance
- .NET Framework 4, Data Access
- .NET Framework 4, Service Communication Applications
- .NET Framework 4, Web Applications
MCPD - ASP.NET Developer 3.5
- Web Developer 4
MCITP - Database Administrator 2008
- Database Developer 2008
 
Open source projects: DBScripter - Library for scripting SQL Server database objects
 

Please, do not forget vote

Sign Up to vote   Poor Excellent
Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

 
You must Sign In to use this message board.
Search this forum  
    Spacing  Noise  Layout  Per page   
GeneralMy vote of 5 Pinmembermahechaw253114 Oct '12 - 4:05 
GeneralRe: My vote of 5 PinmvpKanasz Robert16 Oct '12 - 3:38 
GeneralIt requires ALTER ANY LINKED SERVER permission. PinmvpKanasz Robert30 Nov '10 - 2:59 
GeneralReason for my vote of 5 Good tip. What are the necessary use... Pinmembersjelen30 Nov '10 - 1:52 
Reason for my vote of 5
Good tip. What are the necessary user privileges to execute this code?
GeneralReason for my vote of 5 Thanks for sharing this tip. Pinmemberlinuxjr28 Nov '10 - 12:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Mobile
Web03 | 2.6.130516.1 | Last Updated 13 Nov 2010
Article Copyright 2010 by Kanasz Robert
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid