Knowledge Base

Search the Knowledge Base:
Products:
Search In:
 

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

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.

Keywords

special character; Microsoft

Feedback

Rating: 1 - Lowest 2 3 4 5 - Highest (0 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? (2000 or fewer characters)
Submit
Rating: 1 - Lowest 2 3 4 5 - Highest (0 Ratings)   
Actions
  • KB Article: 1003049
  • Updated: Aug 14, 2009
  • Products:
    VMware VirtualCenter
  • Product Versions:
    VMware VirtualCenter 2.5.x