Post reply

linked server for 2000 is not working ..

  • November 16, 2010 at 6:04 pm

    #229332

    when i am try to use add link server which is 2008 from machine 2000 ,

    sp-addlinked server [2008Machine].. worked fine .. i can see my 2008 Server on 2000 machin Linked server list ..

    but when i am trying to access a table of 2008 , from 2000 machine

    i get this error ..

    Pls.. help how to reslove ..

    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

  • November 16, 2010 at 11:05 pm

    #1251691

    John Paul-702936 (11/16/2010)

    when i am try to use add link server which is 2008 from machine 2000 ,

    sp-addlinked server [2008Machine].. worked fine .. i can see my 2008 Server on 2000 machin Linked server list ..

    but when i am trying to access a table of 2008 , from 2000 machine

    i get this error ..

    Pls.. help how to reslove ..

    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    Hi John,

    Can you try to create a linked server for the following method.

    1. Create a system dsn and configure to sql 2008 db from 2000 machine

    2. In 2000 Machine, you can create a new linked server

    3. General--> Select other datasources--> Microsoft OLEDB Provider for sqlserver

    4. Type the Dsn name in datasource field.

    5. Security-->select final option-- Be made using the security context

    give the appropriate remote user and remote password

    6. click ok

    7. Go to Sql 2000 machine and select * from sysservers

    find out the linked server name

    8. select * from linkedservername.databasename.dbo.tablename.

    Run the above query from 2000 machine.

    Already i confiured from 2000 machine to access to sql 2008 db. Its working.

    Thanks & Regards

    Balaji.G

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply