Search the VMware Knowledge Base (KB)
View by Article ID

VirtualCenter Database Upgrade Fails with an Exception When a Password that Contains Apostrophes or Double Quotes Is Used (1003049)

  • 7 Ratings

Details

When you perform a VirtualCenter database upgrade and the password (and, as a result, the connection string) contains single or double quotes (such as 'my_pwd' or "my_pwd"), the following error results:

System.Data.Odbc.OdbcException: ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. You will not be able to proceed with the VC Database upgrade after this error.

Solution

This problem is the result of a Microsoft bug. Escaping the special character results in a different error and does not resolve the problem. See http://support.microsoft.com/kb/823679 for more information and a Microsoft patch.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 7 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 7 Ratings
Actions
KB: