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