Loading

×Sorry to interrupt
CSS Error

Refresh

Cookie Preference Center

General Information on cookies

When you visit our website, we use cookies to ensure that we give you the best experience. This information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies by clicking on the different category headings to find out more and change your settings. However, blocking some types of cookies may impact your experience on the site and the services we are able to offer. Further information can be found in our

Cookie Policy.

Strictly Necessary

Strictly Necessary

Always Active

Strictly Necessary

Strictly necessary cookies are always enabled since they are essential for our website to function. They enable core functionality such as security, network management, and website accessibility. You can set your browser to block or alert you about these cookies, but this may affect how the website functions. For more information please visit www.aboutcookies.org or www.allaboutcookies.org.

Cookie Details‎

Performance

Performance

Performance

Performance cookies are used to analyze the user experience to improve our website by collecting and reporting information on how you use it. They allow us to know which pages are the most and least popular, see how visitors move around the site, optimize our website and make it easier to navigate.

Cookie Details‎

Please confirm your settings by refreshing the page.

Functional

Functional

Functional

Functional cookies help us keep track of your past browsing choices so we can improve usability and customize your experience. These cookies enable the website to remember your preferred settings, language preferences, location and other customizable elements such as font or text size. If you do not allow these cookies, then some or all of these services may not function properly.

Cookie Details‎

Advertising

Advertising

Advertising

Advertising cookies are used to send you relevant advertising and promotional information. They may be set through our site by third parties to build a profile of your interests and show you relevant advertisements on other sites. These cookies do not directly store personal information, but their function is based on uniquely identifying your browser and internet device.

Cookie Details‎

Advertising Cookies

Consent Leg.Interest

Select All Vendors

Select All Vendors

Select All Hosts

Select All

Clear Filters

Information storage and access

Apply

Confirm My Choices Reject All Allow All

Skip to main content

My Subscriptions

Loading

Knowledge Base

Changing the vCenter Server database user ID and password (1006482)

Last Updated: 2/18/2020Categories: How toTotal Views: 155019Language:
Chinese (Simplified)Portuguese (European)JapaneseSpanishEnglish

1 like this article

Subscribe to get an email
newsletter with new updates

1 people found this helpful Please provide article feedback:

Details

This article describes how to change the vCenter Server database username (this article refers to the username as "user ID"). This article also describes how to change the database password. The user ID and password must be changed when the SQL database credentials on a remote SQL Server are changed.

Note: You may need to change the vCenter Server database user ID and password if you see this error in the Windows Event log:

vCenter not in registry or missing dll - failed to start vCenter.

Solution

Notes:

This solution can only be used for vCenter Server, and not to Update Manager. For Update Manager 4.1 Update 1, see Changing the vCenter Update Manager database password (1034605).

For vCenter Server Appliance using the embedded Postgres database see Changing the default VMware vCenter Server Appliance 5.1 and 5.5 database password (2056968).

For Windows vCenter Server using the embedded Postgres database see How to change the default password of VMware vCenter Server embedded vpostgres database on Windows (56438.

To change the vCenter Server user ID for SQL database connections for vCenter Server 5.x and earlier:

Note: Before making any registry modifications, ensure that you have a current and valid backup of the registry. For more information on backing up and restoring the registry, see the Microsoft Knowledge Base article 136393.

Take a full backup of the registry prior to editing it. Do not skip this step.

Click Start > Run, type regedit and click OK.

In the Windows Registry Editor, navigate to:

HKEY_LOCAL_MACHINE\SOFTWARE\VMware, Inc.\VMware VirtualCenter\DB (under My Computer)

For 32-bit versions of vCenter Server running on 64-bit versions of Windows:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\VMware, Inc.\VMware VirtualCenter\DB

For vCenter Server 5.0:

HKEY_LOCAL_MACHINE\SOFTWARE\VMware, Inc.\VMware VirtualCenter\DB

Note: To see these keys in a 32-bit version of the Registry Editor in a 64-bit operating system, click Start > Run, type %systemroot%\syswow64\regedit, and click OK.

Right-click and click Modify.

Enter the database user ID in the Value data field.

Click OK.

To change the vCenter Server user ID for SQL database connections for vCenter Server 6.x:

Stop the vCenter Server service. For more information, see Stopping, starting, or restarting VMware vCenter Server 6.0 services (2109881).

Navigate to: C:\ProgramData\VMware\vCenterServer\cfg\vmware-vpx.

Take a backup copy of vpxd.cfg.

Open the vpxd.cfg file in a text editor.

Locate the <DB> element and modify the value for <key_2> to reflect the new database user ID.

...
<DB>
<key_2>database_user_id</key2>
<key_3>*joqDY/eQvwyLBdLcXXJYZvDAd+FXYY8q7x///vhy4LE=</key_3>
</DB>
...

If you are using Windows Integrated Authentication to connect to the vCenter Server database, remove the value for <key_3>.

Save the vpxd.cfg file.

Start the vCenter Server service. For more information, see Stopping, starting, or restarting VMware vCenter Server 6.0 services (2109881).

Note: If the vCenter Server database password has changed, use the following steps to update the vCenter Server database password before starting the vCenter Server service.

To update the password used by the vCenter Server for database connections to the SQL Database, use one of these options:

Follow these steps in VMware Infrastructure (VI) Client for VirtualCenter 2.5 only:

Click Administration > VirtualCenter Management Server Configuration.

Click Database.

In the Database Setting page, enter the new password in the Password field.

Click OK.

For VirtualCenter 2.5 Update 2 and later, the -p command line flag sets the database password in vCenter Server:

Click Start, right-click Command Prompt, and select Run as administrator to open a command prompt as an administrator.

Run this command:

For vCenter Server 5.5 and earlier:

C:\Program Files\VMware\Infrastructure\VirtualCenter Server\vpxd.exe -p

For vCenter Server 6.x:

C:\Program Files\VMware\vCenter Server\vpxd\vpxd.exe -p

Note: This is the default path to the vCenter Server installation directory. Change the path appropriately, if required.

Enter a new password when prompted.

Note: If changing any SQL authentication modes or credentials (for example, changing from SQL to Windows authentication), ensure that the ODBC System DSN utilized for the vCenter Server database connection is also updated to reflect the credential changes.

Restart the vCenter Server service. For more information, see Stopping, starting, or restarting vCenter services (1003895) and Stopping, starting, or restarting VMware vCenter Server 6.0 services (2109881).

Additional Information

For translated versions of this article, see:

日本語: vCenter Server データベースのユーザー ID およびパスワードの変更 (2073916)

简体中文: 更改 vCenter Server 数据库用户 ID 和密码 (2086973)

Español: Cambiar el id. de usuario y la contraseña de la base de datos de vCenter Server (2129784)

Português: Alterando a ID de usuário e a senha do banco de dados do vCenter Server (2130030)

Detectable by VMware SkylineTM

Actions

Copy

link to clipboard
copied!

Print

Language:
Chinese (Simplified)Portuguese (European)JapaneseSpanishEnglish

Attachments

Additional Resources

KB
•
End Of General Availability of the Free vSphere Hypervisor (ESXi 7.x and 8.x) (2107518)

KB
•
在 vRA 中，部署/置备请求停滞在“正在进行中”或“待审批”状态 (2114385)

KB
•
Download and Install VMware Fusion (2014097)

Results 1-3 of 3

Ask The Community

Get answers quickly from VMware experts in the community

Post Subject

CONTINUE IN COMMUNITIES

Related Products:

VMware vCenter Server

Related Versions:

VMware vCenter Server 5.5.x

VMware vCenter Server 5.1.x

VMware vCenter Server 5.0.x

VMware vCenter Server 4.1.x

VMware vCenter Server 4.0.x

Take Our Survey

Was this article helpful?

YES

NO

Copyright © 2005-2024 Broadcom. All Rights Reserved. The term “Broadcom” refers to Broadcom Inc. and/or its subsidiaries.

Terms of Use

Your California Privacy Rights

Privacy

Accessibility

Cookie Settings

Support Assistant