Re: Server 6.5 Upgrade
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 25 Dec 2006 23:29:40 +0000 (UTC)
TomH (tnhayes@xxxxxxxxxxx) writes:
I am attempting to run a 2 computer upgrade from SQL Server 6.5 to SQL
Server 2000 over a workgroup LAN. When I run the Server 2000 Upgrade
Wizard, I get the following error message:
"Unable to connect to the Export server. Please verify that you are an NT
administrator on that machine."
What do I need to do to correct this. I am not an experienced databas
administrator. The Microsoft documentation makes a passing reference to
the need for administrative privledge but, as is typical for them, it
assumes that you already know what is being talked about and how to go
about doing it. Any help would be appreciated.
This looks like a Windows networking issue to me. Getting things like
integrated security work in a workgroup is not always easy. If you can
run the wizard with SQL authentication, do that. But I suspect that
the access is also needed to be able to access files on disk.
The alternative to running the upgrade wizard, is to run it all by hand.
Script the database (if you don't have the code under version control),
from Enterprise Manager in 6.5 and run the script on SQL 2000. Use BCP
to copy the data in and out. Finally, there are users and logins to take
care of.
Another option is to install a named instance of SQL 2000 on the same
machine as 6.5. Once you've manage to migrate the 6.5 databases, you
move the database to the real SQL 2000 server with BACKUP/RESTORE or
sp_detach_db/sp_attach_db. (I need to add the disclaimer that I am not
sure whether it is supported to install SQL 2000 alongside SQL 6.5.)
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: sql2005 "Invalid Owner.."
- Next by Date: Re: sql2005 "Invalid Owner.."
- Previous by thread: sql2005 "Invalid Owner.."
- Next by thread: No Import/Export Option in Mgmt Studio Express
- Index(es):
Relevant Pages
|
