VMware

This Question is Possibly Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (6 pts)
1 Replies Last post: Oct 31, 2007 9:43 AM by WillemB  

VC 2.0.2 upgrade fails with SQL case sensitive error posted: Oct 31, 2007 9:10 AM

Click to view mark_a_k's profile Enthusiast
mark_a_k
49 posts since
May 4, 2007
When attempting to upgrade the version of Virtual centre from 2.0.0 to 2.0.2 I have the following eror message.

VirtualCenter Server Does Not Support Case-Sensitive SQL Server Installation and Case-Sensitive SQL Server Database
If the DSN provided during the VirtualCenter Server installation points to a case-sensitive SQL Server instance or a case-sensitive SQL Server database, the installation fails and an error message is displayed. This is expected behavior. Before running the installation again, ensure that you have a case-insensitive SQL Server instance and a case-insensitive SQL Server database

Does anyone know how to turn off case-sensitivty on the SQL database?
Any reference I found on the internet does not instruct how to turn if off but points to the database properties-> Collation Name ->Latin1_General_Cl_AS as the indication that case sensitivity is turned on.

THANKS for any help.

Re: VC 2.0.2 upgrade fails with SQL case sensitive error

1. Oct 31, 2007 9:43 AM in response to: mark_a_k
Click to view WillemB's profile Hot Shot
WillemB
111 posts since
Jan 29, 2007

Maybe you should look at the collation at server level.

Other than that I can't remeber having any problems like this with VC installation on SQL2000.

Try running a test on the VirtualCenter ODBC system DSN object and see if you get an MS error of somesort. An MS error would have to be solved before installation of VC.

You could try making your username and/or password all capitals or non-capitals and see if that can work as a work-around.


Actions

VMware Developer

SDKs, APIs, Videos, Learn and much more in the Developer community.

Learn More

Developer Sample Code

Increase your developer productivity with VMware API sample code.

Learn More

VMworld Sessions & Labs

Online access to the latest VMworld Sessions & Labs and online services.

Learn more

Purchase PSO Credits Online

Purchase credits to redeem training and consulting services online.

Buy Now

Community Hardware Software

View reported configurations or report your own.

Learn More

VMware vSphere

Come witness the next giant leap in virtualization.

Register Today

Communities