Creating a linked server from SQL 7 to SQL 2005

Posted on 2007-10-16
Last Modified: 2012-06-27

I've been asked by the IT Manager to create a linked server one production SQL server (SQL 7.0) to another production SQL server (SQL 2005).

The SQL 2005 box is externally hosted, but our network guy says there is nothing hitting the firewall.

I can link from the sql 7 box to anothe 2005 box in our lan ...

A test SQl 7 box can link to the external 2005 instance.

This has never worked, I'm trying to set it up.

The dilema is that if the problem was due to SQL or anything to do with the SQL 7 server, then it shouldn't connect to any SQL 2005 instance. But it does.

But then neither does it appear to be anything on the firewall.

If I telnet SQL2005Server FixedPort I get a connection, so that would tend to confirm the network guy's view that it isn't the network or firewalls or vpn.

Thanks in advance
Question by:David Todd
    LVL 35

    Accepted Solution


    Solved it! There was an incorrect Alias setup! Removed it an it all worked!

    LVL 1

    Expert Comment

    Closed, 500 points refunded.
    Community Support Moderator

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how the fundamental information of how to create a table.

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now