[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 Exception thrown while executing SQL script
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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.