Linked Server

Discussion in 'Databases' started by 1PabloAngel, Dec 21, 2011.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. 1PabloAngel

    1PabloAngel

    Hi, I'm trying to link to my DASP SQL 2008 server from a local SQL 2008 server but am having exactly the same problem that 'theguyver' was in his thread 'How to create a Link to a DASP SQL Server?' from 07/09/2008 (now locked). I've quoted the full error message I'm getting when trying to connect to the linked server below:


    Both servers are SQL 2008. In the General tab I've selected SQL SERVER, put in ESQL2k801.DISCOUNTASP.NET under linked server. Then on the Security tab used the full SQL login security context. Anyone got any ideas why this isn't working?

    Thanks in advance.
     
    1PabloAngel, Dec 21, 2011
    #1
  2. RayH

    RayH DiscountASP.NET Lackey DiscountASP.NET Staff

    To create a linked server on your local development environment:

    1) Log into your local SQL Server instance on your development machine.
    2) Expand the Server Objects -> Linked Servers folders.
    3) Right click on the Linked Servers folder and select "New Linked Server..."
    4) In the General section, type in the fully qualified domain name for the Linked Server and check SQL Sever.
    5) In the Security section, check "Be made using this security context:"
    6) Enter your database login credentials.
    7) Click on OK.

    Please note that we do not support linked servers from our environment.

    If it's failing, you might want to try disabling antivirus/firewall software.
     
    RayH, Dec 22, 2011
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page