Exception thrown while executing SQL script.

Applies to: Microsoft SQL Server 2005, VMware vCenter Server 4.1
 

Problem Description.
 

While upgrading vCenter Server 4.0 to vCenter Server 4.1 we received the following error from the setup program:

Exception Thrown while executing SQL script
 

Cause.

The vcenter database on the SQL Server 2005 instance had a compatibility level of 80 (SQL Server 2000). vCenter 4.1 is supported on compatibility level 90 (SQL Server 2005) or later.


Solution.

The solution is restoring the database from backup and changing the compatibility level to 90 (native SQL Server 2005).

To change the compatibility level to 90 or later, please perform the following steps:

1. Connect to the SQL Server instance and expand the "Databases" folder.

2. Right click on the "vcenter" database and choose Properties.




 

3. In the "Select a page" pane, click "Options".

4. On the "Compatibility level" combo box, select "SQL Server 2005 (90)" or "SQL Server 2008 (100)".

References.


Upgrading vCenter Server 4.0 to 4.1 fails with the error: Exception Thrown while executing SQL script.

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.