April 5, 2005 at 9:49 pm
Good day
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
April 6, 2005 at 6:26 am
Have you tried just connecting to the SQL 7 instance from your machine with QA to verify you can get connected?
April 7, 2005 at 6:23 am
I would agree that would be a good idea. There should be no issues using dts to transfer from 2000 to 7.0. There can be issues opening packages in Enterprise Manager 2000 that were created in Enterprise Manager 7 due to differences in the way they are stored, but a direct connection to the database shouldn't be a problem. Let us know if you have tested the connectinon using QA.
April 8, 2005 at 5:32 am
Sorry for the delayed response - No I hadnt tryed QA connectivity. I ended up dts'ing from the 7.0 machine to the 2000 (import), exporting like I suggested above from 2000 to 7.0 failed - my problem is solved however should this be possible?
Problem solved but - my primary keys, diagrams and users did not transfer - should they have? No problems creating a new user but PK's and diagrams are a different story.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply