check the VCDatabaseUpgrade.log (%temp%), if the db upgrade fails during vcenter 4.1 installation;
if the error
Got exception: ERROR [42000] [Microsoft][SQL Native Client][SQL Server]CREATE INDEX failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.
occurs, follow
vmware kb note 1024449:
1. Connect to your MS SQL database with Management Studio.
2. Right-click on the server and choose New Query.
3. In the query window type and execute:
sp_configure 'user options', 64
reconfigure
The reconfigure takes one minute or more, depending on the database.
-------------
if you try the upgrade under mssql2008 server german edition, you might find the following error:
Error: Failed to execute command: INSERT INTO VPX_LIC_METADATA(LAST_SAMPLE_ID, LAST_SAMPLE_TIMESTAMP, RETAINED_SAMPLE_ID, RETAINED_SAMPLE_TIMESTAMP, GLOBAL_DIGEST, IS_STATE_VALID, WEEK_KEEP_COUNT) VALUES(0, '1900-12-31 00:00:00', 0, '1900-12-31 00:00:00', NULL, 1, 208)
Got exception: ERROR [22007] [Microsoft][SQL Server Native Client 10.0][SQL Server]Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
copy the whole vpx folder to c:\temp (or something), add to C:\temp\vpx\dbupgrade\bin\Upgrade-v400-to-v410\mssql\upgrade_mssql.sql before the insert statement "SET DATEFORMAT ymd" (last but one line).
of course: make backups from your db & try it at your own risk
