Creating a linked server from SQL 7 to SQL 2005

Posted on 2007-10-16
Medium Priority
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

David Todd earned 0 total points
ID: 20090542

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


Expert Comment

ID: 20135022
Closed, 500 points refunded.
Community Support Moderator

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
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
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

864 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