Connect SQl Server 2000 to 7.0

[ChrisQuick]

Hi,

I have a new machine running SQl Server 2000.

We have an existing database running on SQl Server 7.

I know it *should* be possible to connect from 2000 to 7.

Can anyone give me some suggestions, and how to information? cquick@geotg.com
Geographic Information System (GIS), ASP, some Oracle

 

[fluteplr]

look at linked servers in BOL (Books on Line).

 

[aalmeida]

Open SQL 2k Enterprise Manager right click on SQL Server Group, Select Register New SQL Server and follow it, that should do it AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[ChrisQuick]

aalmeida, I've tried that. It attempts to connect and Gives us a timeout error. Strange thing is, I can connect to the SQl Server 7 database through SQl Query Analyzer. cquick@callingpost.com
Geographic Information System (GIS), ASP, some Oracle