Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
 Posted - 2002-01-07 : 13:14:15
|
| Hi,We are trying to migrate sql server database from 6.5 to 2000.We installed 6.5 and then 2000 on the same machine. We started upgrade wizard. It seemed it's working fine but after a while it came with a error login failed for sa. We thought we should check the properties of sa login on sql 2000. But now we can't connect to sql 2000. It's saying you need to upgrade the server to sql7.0. Both databases are installed locally on the same machine.What's going on?Thanks for any help.Rita |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-01-07 : 13:17:01
|
| The upgrade upgrades to v2000 - i.e. it does the installation as well.It's probably having problems because there is already a version there.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
Posted - 2002-01-07 : 13:54:43
|
| HI, I am looking on msdn. It says:How To Upgrade from SQL Server 6.5The How To topics in this section are specific to the process of converting data from Microsoft® SQL Server™ 6.5 to Microsoft SQL Server 2000 using the SQL Server Upgrade Wizard.Note To run the SQL Server Upgrade Wizard, you must have an instance of Microsoft SQL Server 2000 already installed on your computer.Considerations when upgrading from SQL Server 6.5:During the upgrade process, the SQL Server 6.5 server is stopped and started while objects are scripted and data is extracted. When the data transfer starts, only SQL Server 2000 is running, and it is not possible to access SQL Server 6.5. |
|
|
|
|
|
|
Migration from 6.5 to 2000