I am getting a "error during initialization of provider - SQL Server does not exist or access denied" error when trying to DTS from a 2000 instance to a 7.0 instance. The instances are on seperate machines within our network.

What I do know:
1..there are definatly no firewall or the like barriers between the two machines.

2..The sa passwords on both machines are correct - I have tripple checked these.

3..To establish the machines can see each other I can see each others machine/instance name from one another.

Where does it start to go wrong when DTS'ing:
1..On the 2000 machine I right click the DB/All tasks/Export Data.
2..DTS opens/Next.
3..Choosing a data source - I select the local machine (yes I can see all other SQL Instances in our network including the 7.0 version)I then choose SQL Authentication entering the sa details and select my source DB.
3..Choosing a destination - Once agin I can see all instances in the 'Server' drop down I choose the 7.0 instance name and enter the sa details. When I click the 'Database' drop down to select my the newly created empty DB to transfer to - it thinks for abour 30 seconds and comes back with the error detailed in the head of this post--------error---------------
4..I then went into the advanced tab adjacent to the 'Database' drop down and entered the machine name, ip address - still no joy

Any help would be appreciated - can you DTS from 2000 to 7.0? has anybody done this?

TYIA



Wind is your friend
Matt

__________________
Wind is your friend
Matt

I'm not sure if it's required for DTS but have created a relationship between the two servers in Linked Servers (under Security)?

No I havnt - I dont think this is required for DTS.

My solution: I would have thought you could DTS from the 2000 Enterprize Manager (export) to the 7.0 instance (steps illustrated above) - no joy there, it simply can not be done. It worked the other way round, you may DTS (import) from 7.0 instances EM pulling the information from the 2000 instance. However - none of my primary keys came through, datatypes yes.

Did I miss something? Should the primary keys come through?

Wind is your friend
Matt