You must use a domain account, not Network Service, for server farm upgrades
For either in-place or gradual upgrade in a server farm environment, you should use the same credentials that you used in the version 2 environment in your version 3 environment. However, if you were using the Network Service account for your version 2 environment, you must instead use a domain account in version 3. Your version 2 environment can continue using Network Service, but when you install version 3 and create the new farm, you must supply a domain account instead. Be sure that you grant the domain account that you use the appropriate rights to the databases in SQL Server (must be a member of the database creators, process administrators, and database owners group for all version 2 databases).
Some settings are not preserved on the Web application when you perform an in-place upgrade
If you use Secure Sockets Layer (SSL) and perform an in-place upgrade, you must use the Alternate Access Mapping (AAM) feature to modify the URL within Windows SharePoint Services because some settings are not preserved on the Web application.
Before you upgrade, if you have an AAM entry that uses HTTPS, such as the following:
Incoming URL: https://<server name>
Outgoing URL: https://<server name>
After you perform an in-place upgrade of Windows SharePoint Services 3.0, this entry will be incorrectly set to:
Incoming URL: https://<server name>
Outgoing URL: http://<server name>
To correct the URL, on the SharePoint Central Administration Web site, on the Operations page, click Alternate Access Mappings, and then click Edit Public URLs to set the URL back to:
Incoming URL: https://<server name>
Outgoing URL: https://<server name>
For more information about alternate access mappings, see Plan alternate access mappings (Windows SharePoint Services).
Upgrade finishes on the first front-end Web server but has failures
In a farm that uses multiple front-end Web servers, if the upgrade finishes on the first front-end Web server but has failures, we recommend that you solve the problem and rerun the upgrade before you move on to upgrade any additional front-end Web servers.
If, for some reason, you want to disregard the failure (for example, because the failure has to do with a rarely used site collection), you can move on to upgrade the second front-end Web server by using the Psconfig command-line tool. Use the following command-line operation:
Psconfig -cmd upgrade -inplace b2b -wait -force
Note: |
|---|
You cannot use the SharePoint Product and Technologies Configuration Wizard to upgrade additional front-end Web servers if you use the Psconfig command-line tool. |
SPConfigurationDatabase2 sequence error in the upgrade log
If you perform an in-place upgrade and it fails, check Upgrade.log, which is located in the COMMONPROGRAMFILES%\Microsoft Shared\Web server extensions\12\LOGS folder. If you receive the following error message: “[SPConfigurationDatabaseSequence2] [ERROR] [date]: The role 'WSS_Content_Application_Pools' already exists in the current database,” you can use any of the following workarounds to solve the problem:
Run the following SQL queries on the configuration database.
delete from dependencies
delete from objects
delete from classes
delete from sitemap
exec sp_droprole N'WSS_Content_Application_Pools'
Note: |
|---|
If the drop role has any members when the action failed, the sp_droprole call returns the names of those members. You must then run the following command for each member. |
exec sp_droprolemember N'WSS_Content_Application_Pools',
N'usernameReturnedFromSP_DropRole'
Then you must run the following query again.
exec sp_droprole N'WSS_Content_Application_Pools'
Create a new V3 farm, and then attach the existing content database. This option will retain all the user data, but will lose configuration information that was stored in the V2 configuration database, such as Web Part packages and virtual server settings.
If the original failure was addressed (for example, the failure was due to lost network connectivity or insufficient SQL Server computer disk space and then corrected), you can restore the V2 farm and then restart the upgrade.
Note: |
|---|
Remember to restart the upgrade after you have performed the workarounds. |
For in-place upgrades on stand-alone servers, run upgrade from the command-line if you get an error with a login failure or connection failure to the database
If you are running an in-place upgrade on a stand-alone server running WMSDE, the upgrade process might time out and generate an error similar to the following:
SPContentDatabaseSequence] [ERROR] [10/18/2006 12:42:44 PM]: Cannot open database "STS_DATABASE_NAME_1" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
[SPContentDatabaseSequence] [ERROR] [10/18/2006 12:42:44 PM]: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
If you see this error, or an error about a database connection failure, you must use the command-line to complete the upgrade.
-
Open a command prompt window and change to the following directory: %COMMONPROGRAMFILES%\Microsoft Shared\web server extensions\12\bin
-
Run the following command to resume and complete upgrade:
psconfig –cmd upgrade –inplace v2v –force -wait
For more information about using the psconfig.exe command-line utility, see Command-line reference for the SharePoint Products and Technologies Configuration Wizard (Windows SharePoint Services).