Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Exclamation Unanswered: Linked Server (SQL 2000 to SQL 6.5)

    Hi,

    I am trying to setup up a linked server using 'sp_addlinkedserver'. The host server is a SQL 2000 and the remote server is SQL 6.5. Both the servers are on the same domain.

    When the system stored procedure is run, enterprise manager shows the name of the linked server but there are no tables.

    I get error 'SQL Server does not exist or access denied' when trying to run query against a database on the remote server.

    Does SQL server 6.5 support linked servers?

    Please help,

    DPKA

  2. #2
    Join Date
    Jan 2004
    Posts
    2

    Re: Linked Server (SQL 2000 to SQL 6.5)

    Originally posted by DPKA
    Hi,

    I am trying to setup up a linked server using 'sp_addlinkedserver'. The host server is a SQL 2000 and the remote server is SQL 6.5. Both the servers are on the same domain.

    When the system stored procedure is run, enterprise manager shows the name of the linked server but there are no tables.

    I get error 'SQL Server does not exist or access denied' when trying to run query against a database on the remote server.

    Does SQL server 6.5 support linked servers?

    Please help,

    DPKA
    Hi from me again,

    now I am able to add the SQL server 6.5 database as a remote database but when trying to run a query against a table on this remote database, i get 'Server: Msg 18456, Level 14, State 1, Line 1
    Login failed for user '\'.

    I have used the stored procedures sp_helplinkedsrvlogin and sp_addlinkedsrvlogin and have access to both the databases.

    Any help appreciated,

    DPKA

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Well....did you set up permissions on the linked server?

    Even if you ass a linked login, it still has to be known to the server....

    I have never tried adding a link to 6.5 though....

    but I did find this in BOL

    Note To use the Microsoft OLE DB Provider for SQL Server 2000 in SQL Server version 6.x, run the \Microsoft SQL Server\MSSQL\Install\Instcat.sql script against the version 6.x SQL Server. This script is essential for running distributed queries against an SQL Server 6.x server.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jun 2003
    Location
    VA, USA
    Posts
    3

    Wink You can add any Linked server with ODBC

    Basically you can add any database as a linked server if that has ODBC driver.
    Recently I've added SQL Server 6.5 Linked server in my SQL Server 2005 server!

    Please refer to the below link for detail.
    http://knol.google.com/k/jeyong-park...ywlm4f31xae/6#

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •