Microsoft KB Archive/242158

= SQL Server 6.5 to 7.0 Migration Issues =

Article ID: 242158

Article Last Modified on 8/4/2000

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition

-



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:

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



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  command, and then restart the services by executing the Net Start  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 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.

Additional query words: ss3 sp2 kbreadme readme akz

Keywords: kbhowto KB242158

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.