SQL Server 6.5 to 7.0 Migration Issues (242158)

SUMMARY

The "More Information" section of this article contains specific SQL Server 6.5 to 7.0 migration issues; it does not cover all the Site Server 3.0 and SQL Server 7.0 issues. For additional Site Server 3.0 and SQL Server 7.0 compatibility issues, please see the following Web page:

How to Install Site Server 3.0 with All Updates with SQL Server 7.0 Installed

MORE INFORMATION

Stop and Restart Site Server 3.0 Services

If you are installing SQL Server 7.0 on a computer that is running the Site Server 3.0 components, you must stop the following associated services before performing the upgrade:

IIS Admin
Site Server Content Deployment
Site Server Gatherer
Site Server Search

From a command prompt, execute the Net Stop <service name> command, and then restart the services by executing the Net Start <service name> command when the upgrade is complete.

Changing the SQL Server 7.0 "sa" Password

If you run the database upgrade wizard immediately after installing SQL Server 7.0, you may not have changed the SQL Server 7.0 "sa" password to that of the SQL Server 6.5 "sa" password. To do so, first exit the upgrade wizard, and then change the "sa" login from its default value of <null> to the "sa" value specified in the SQL Server 6.5 installation. Re-run the wizard, or change the password immediately after you upgrade the database(s).

Support for SQL Server 6.5 Emulation Mode and SQL Server Switch

SQL Server 7.0 ships with a feature that allows for SQL Server 6.5 emulation after you upgrade to a SQL Server 7.0 environment. Site Server 3.0 is not supported in this environment, and customers must upgrade Site Server databases from SQL Server 6.5 to SQL Server 7.0 at the time of upgrading their SQL Server computer.

When you upgrade from SQL Server 6.5 to 7.0 on the same computer, the SQL Server Switch command allows you to toggle between version 6.5 and 7.0 environments. Site Server is not supported when the Switch command has been employed to toggle from a 7.0 environment to a 6.5 environment. To revert back to a supported environment, you must toggle back to the 7.0 environment.