blog sistemITecblog sistemITec

    Subscribe to Updates

    Get the latest creative news from FooBar about art, design and business.

    What's Hot

    Schedule a job on Aruba Switch

    July 5, 2023

    How to decrypt and verify text or files with GPG Services

    June 28, 2023

    How to send WhatsApp messages to someone without saving their phone number

    June 19, 2023
    Facebook Twitter Instagram
    • sistemITec website
    • contact us
    Facebook Instagram YouTube LinkedIn
    blog sistemITecblog sistemITec
    • IT Fundamentals
        Featured
        IT Fundamentals

        How to send WhatsApp messages to someone without saving their phone number

        By Cornel CabaJune 19, 20230
        Recent

        How to send WhatsApp messages to someone without saving their phone number

        June 19, 2023

        Network Topology Guide

        June 19, 2023

        Top 20 Essential ESXCLI Commands

        June 19, 2023
      1. Gaming
          Featured
          Gaming

          Application load error 5:0000065434 in Steam

          By sistemitec's teamAugust 8, 20210
          Recent

          Application load error 5:0000065434 in Steam

          August 8, 2021

          The Best Overlooked Video Game Of 2020

          August 2, 2021

          Hearts of Iron IV Review

          August 2, 2021
        1. Software
            Featured
            Software

            Schedule a job on Aruba Switch

            By Cornel CabaJuly 5, 20230
            Recent

            Schedule a job on Aruba Switch

            July 5, 2023

            How to decrypt and verify text or files with GPG Services

            June 28, 2023

            Windows Server 2019/ Product Key Free

            June 19, 2023
          1. Gadgets
              Featured
              Gadgets

              How to Simulate Arduino Projects With Proteus

              By Cornel CabaMarch 17, 20220
              Recent

              How to Simulate Arduino Projects With Proteus

              March 17, 2022

              How connect Apple AirPods to a Windows PC

              February 10, 2022

              How to Put Ebooks on Amazon Kindle

              October 12, 2021
            1. Tech
                Featured
                Tech

                Lenovo Unveils IdeaPad Laptops, 5G Internet & a Snapdragon 8cx Chipset

                By Cornel CabaJanuary 15, 20210
                Recent

                Lenovo Unveils IdeaPad Laptops, 5G Internet & a Snapdragon 8cx Chipset

                January 15, 2021

                2021 Apple MacBook Air: Apples New Leak Reveals Razor-thin Redesign

                January 15, 2021
                8.9

                Review: Xiaomi’s New Loudspeakers for Hi-fi and Home Cinema Systems

                January 15, 2021
              blog sistemITecblog sistemITec
              Home»Software»How to Add SQL Linked Server on SQL Server
              Software

              How to Add SQL Linked Server on SQL Server

              Cornel CabaBy Cornel CabaMarch 2, 2022No Comments2 Mins Read
              Facebook Twitter Pinterest LinkedIn Tumblr Email
              Share
              Facebook Twitter LinkedIn Pinterest Email

              This SQL Server 2012 tutorial shows how to add linked server to SQL Server 2012 instance.

              Here is a step by step SQL Server linked server creation process:

              1.) Connect to SQL Server 2012 database instance using SQL Server Management Studio (SSMS) with a SQL login that has sysadmin server role.
              Within Object Explorer window, drill-down from SQL Server instance node to Server Objects > Linked Servers node.
              Right click on the Linked Servers node, and choose New Linked Server… from context menu.

              create new linked server on SQL Server 2012

              2.) Then the create New Linked Server wizard screen is displayed as seen in below screenshot.
              On the wizard screen, you can add linked server using two methods according to the target server type. These two options are one for SQL Server server type and one for Other data source server types.

              create new linked server wizard

              If the target server for new linked server is SQL Server, then choose server type as “SQL Server“. The only configuration parameter on this screen is the name of the SQL Server instance. You can provide SQL Server instance name in the “Linked Server” textbox.
              Then other input areas will turn into grey, non-editable input textboxes.

              If the SQL Server is default instance then it is enough only to enter the server name. But if the SQL Server instance is a named instance then you can define the linked server name in “[servername\instancename]” syntax.

              SQL Server linked server type

              3.) Switch to Security page (or tab) in order to define security context.
              After target SQL Server instance is defined, next step is providing the security context (username password information) used when executing sql commands over the SQL Server linked server.

              SQL Server linked server security, login name and password

              In security page, you can map local SQL Server login to remote server login. And the bottom section of the security tab, you can define default security context for connections over linked server. You have the following options:
              Not be made,
              Be made without using a security context,
              Be made using the login’s current security context,
              Be made using this security context: (Here you should provide remote login name and password)

              After security context is also completed, press OK button to create linked server on SQK Server 2012.

              linked server server sql
              Share. Facebook Twitter Pinterest LinkedIn Tumblr Email
              Previous ArticleAmazon Bucket S3 Cloud Storage Costs Explained
              Next Article How To Move the Taskbar to the Left or Right on Windows 11
              Cornel Caba
              • Website

              Related Posts

              Schedule a job on Aruba Switch

              July 5, 2023

              How to decrypt and verify text or files with GPG Services

              June 28, 2023

              Windows Server 2019/ Product Key Free

              June 19, 2023

              Sysprep Windows 10 and 11 Machine: Step by Step Guide

              June 19, 2023
              Add A Comment

              Leave A Reply Cancel Reply

              Editors Picks

              Shrinking VMDK Virtual Disk Size on VMWare ESXi

              August 11, 2022

              Oculus Quest X Headset: Discover a Shining New Star

              January 5, 2021

              iPhone Pro 13 Rumored to Feature 1 TB of Storage

              January 5, 2021

              Fujifilm’s 102-Megapixel Camera is the Size of a Typical DSLR

              January 5, 2021
              Top Reviews
              9.1

              Review: Mi 10 Mobile with Qualcomm Snapdragon 870 Mobile Platform

              By Cornel Caba
              8.9

              Comparison of Mobile Phone Providers: 4G Connectivity & Speed

              By Cornel Caba
              8.9

              Which LED Lights for Nail Salon Safe? Comparison of Major Brands

              By Cornel Caba
              Advertisement
              © 2023 sistemITec. Designed by Cornel Caba.
              • sistemITec.com
              • cornelcaba.com

              Type above and press Enter to search. Press Esc to cancel.