SQL Server 6.5 to 7.0 Migration Issues (242158)



The information in this article applies to:

  • Microsoft Site Server 3.0

This article was previously published under Q242158
NOTE: The information in this article was originally included in the Site Server 3.0 Service Pack 2 Readme_sp2.htm file.

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:

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.

Modification Type:MajorLast Reviewed:8/4/2000
Keywords:kbhowto KB242158