473,569 Members | 2,788 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL 6.5 upgrade to 2000

Hi,
I am trying to use the Upgrade Wizard in SQL 2000 to upgrade a SQL 6.5 db to
2000. I am only choosing to update a single database, not system objects.
The Upgrade wizard connects to SQL 6.5, checks the db, creates the db on SQL
2000 with all tables and imports users from SQL 6.5. The problem comes when
it tries to bring over the actual data. I get an error:
"Couldn't connection to the export machine!" in the out log file.
The in log file reports login failed.
Both SQL services were running at this point, the login via SA must be
working since it copies over the 6.5 db structure and users.
The SQL 6.5 machine is NT 4. The 2000 machine is Windows Server 2003. I
was logged in as domain admin when running this. I tried playing with the
"SQLUpgrade " DSN that was created on the SQL 2000 machine to use SA or
windows authentication, both fail.

Any ideas?
Thanks.
Aug 4 '06 #1
1 1874
Hi

I have never used the wizard to upgrade from 6.5 as I tend to use BCP as
this gives you better overall control. A guess would be the directory or
share permissions are not correct.

John

"rdraider" <rd******@sbcgl obal.netwrote in message
news:FM******** *********@newss vr12.news.prodi gy.com...
Hi,
I am trying to use the Upgrade Wizard in SQL 2000 to upgrade a SQL 6.5 db
to 2000. I am only choosing to update a single database, not system
objects.
The Upgrade wizard connects to SQL 6.5, checks the db, creates the db on
SQL 2000 with all tables and imports users from SQL 6.5. The problem
comes when it tries to bring over the actual data. I get an error:
"Couldn't connection to the export machine!" in the out log file.
The in log file reports login failed.
Both SQL services were running at this point, the login via SA must be
working since it copies over the 6.5 db structure and users.
The SQL 6.5 machine is NT 4. The 2000 machine is Windows Server 2003. I
was logged in as domain admin when running this. I tried playing with the
"SQLUpgrade " DSN that was created on the SQL 2000 machine to use SA or
windows authentication, both fail.

Any ideas?
Thanks.


Aug 6 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2053
by: kg7poe | last post by:
We have Sqlsvr 6.5 under NT4. We want to upgrade the database to Sqlsvr 2000 under windows 2K. Is there any way we can do this by copying the database to the win2K computer?? At any rate would someone explain how to go about updating this. I know nothing about sqlsvr anyversion but do need to know. TIA
2
2116
by: Saiyou Anh | last post by:
Hi! If doing online version upgrade from SQL 7.0 to SQl 2000, (1) do I need to shut down server? (2) after upgrading, is all login and db user, group information, scheduled Jobs, maintenance paln... still there? or I have to save the info before upgrading and recreate after upgrading? (3) any other tips I need to know? I'm doign that for the...
2
1990
by: Matt | last post by:
Hello All I have SQL Server versions 6.5 and 2000 installed on a Windows 2000 server. I installed 6.5 first, coppied a backup of a database to the server and restored it. I then installed 2000. I am trying to use the upgrade wizzard. On the first screen I keep the default settings, export and import
2
2506
by: Trevor Hughes | last post by:
Hello All Our organisation has recently upgraded its operating system to Windows 2000. Prior to this I was running Access 2000 databases on NT machines using the Access 2000 Runtime with no problems. Since the upgrade I am experiencing runtime errors which are making parts of the database unusable. The database will crash when I run a...
2
1717
by: DonLi | last post by:
Hi, I have a copy of Access 97 while my client uses Access 2000 which supports Unicode. My client has ordered a copy of Access 2000 upgrade for me, but the middleman, atomicpark.com is totally ABSURD, first they delayed delivery and secondly when they sent the ordered product they sent me a badly damaged CD, when I asked for replacement...
47
4485
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!
4
2708
by: Laphan | last post by:
Hi All I know that if SQL 6.5 was on a server and you then install SQL 2000 on it you get the wizard option to upgrade an SQL 6.5 DB to 2000, but I don't have the luxury of this. I have an SQL 6.5 DB, which I want to convert, but only SQL 2000 on my server. Do you know what options I have available to me to perform this upgrade with
2
8460
by: KR | last post by:
Hi, We are running a test upgrade form sql 2000 standard edition to sql 2005 developer edition. Followed through all the steps and specified the account(SA priveleges and currently used by the 2000 version) and is the local admin on the box for the services and the setup seemed to move fine, except for when it got to the point of installing...
3
4129
by: Mark D Powell | last post by:
I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) to SQL Severer 2005 EE 32 bit and while the prereqs passed the installer will not let me select the version 8.00.x (2000 SP4) database that it finds on the server. When I ckeck the install details it tells me that "Your upgrade is blocked becuase of cluster upgrade rules"...
0
7697
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7612
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7924
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8120
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7672
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7968
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6283
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
1212
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
937
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.