Creating Linked Server for Microsoft SQL Server 2008

 

Creating Linked Servers (SQL Server Database Engine)

1.       Login in to the source server  using  login user with sysadmin privilege

2.       From the Object Explorer, expand the server objects folder and right-click the linked server folder to create new linked server

           3.  Self Explanatory

       4. Self Explanatory

            5. Self Explanatory

      

          6.   Self Explanatory

          
            7. Self Explanatory

      
            8. Self Explanatory

             The configuration of Linked Server in Microsoft SQL Server 2008 is completed.