Whether you decide to perform a one-computer upgrade (installing SQL Server 7.0 on existing hardware), or a two-computer upgrade (installing SQL Server 7.0 on a new computer), the information in the rest of this chapter relates to these upgrades similarly. A one-computer upgrade is simply a special case of a two-computer upgrade for which the import and export computers are the same physical computer.
The first step is to obtain the system administrator user password for both the export and import servers. Your Windows NT logon must also be a member of the Windows NT Administrators local group on both the export and import servers. You must leave the SQL Server 7.0 installation in SQL Server and Windows NT Authentication Mode for the duration of the upgrade. If you want to run in Windows NT–only mode (Integrated Security mode in SQL Server 6.x), switch to this mode after the upgrade is complete.
If you use SQL Server 6.x Integrated Security logins that are mapped to any Windows NT local groups, those groups must exist on the import server with the same group and user membership that exists on the export server.