February 19, 2003 at 7:21 am
During an upgrade using the Wizard, I get an error during the 'Export and import via named Pipe' task. The upgrade terminates and creates an error file which says
'CNVPIPE - CApp::CApp - Couldn't connection to the export machine!'
I've searched the Microsoft website but found nothing useful.
Any help appreciated.
February 19, 2003 at 8:32 am
You cannot use the Upgrade Wizard to move a 6.5 server to 2000, you have to go to 7 then 2000.
Otherwise you have to use the DTS Import/Export wizard but it may not get all details in the copy.
February 19, 2003 at 8:40 am
Antares - you are usually the font of all knowledge but not on this occasion. Read BOL 'Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)'
BTW - I've been searching round the web and think this has something to do with domains, account privileges etc
February 19, 2003 at 11:10 am
Hem, seems I was wrong. Thanks for pointing that out. I will see what I can find out.
February 19, 2003 at 11:19 am
February 20, 2003 at 5:02 am
Thanks for the reply. There are no spaces in any directory names so I dont think thats the problem.
The upgrade worked fine on 2 test servers. It is now failing in the production environment. The differences are
1. Prod servers were in different domains
2. prod. servers are in a DMZ with a firewall
3. test servers were using SQL 200 SP2. Prod servers are using SQL2000 SP3
I found this thread
http://www.sqlmag.com/Forums/messageview.cfm?catid=15&threadid=8205
and am currently working through the suggestions to see if I can get an upgrade to work.
I'll keep you posted. In the meantime, any other help would be appreciated.
February 20, 2003 at 5:46 am
If nothing found in the KB then I'd go for the working solution. Upgrade to sp2 move the 6.5 dbs and afterwards upgrade to sp3.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 20, 2003 at 9:41 am
Success !! The upgrade worked first time with SP2 + security fix applied.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply