Scenario: I needed to upgrade vSphere from 5.1 to 5.5. Microsoft SQL 2005 is no longer supported so I needed to move the vCenter database from the local machine to dedicated SQL 2008 server before the upgrade. I also had the SSO and Update Manager Database on this local machine. Instructions for moving the SSO DB Read More…
Day: February 19, 2015
User, group or role ‘RSA_user’ already exists in the current database
Scenario: I backed up the vCenter SSO database and copied & restored it from an SQL2005 to an SQL2008 server. This worked fine but when I tried to add the user mapping I got the following: Create failed for User 'RSA_user'. (Microsoft.SqlServer.smo) This occurred because the user I was trying to add already existed in Read More…
Migrating SSO Database from SQL 2005 to SQL2008
I wanted to move the SSO database from the local vCenter server to a dedicated SQL 2008 server. 1) Obtain the password the RSA_DBA and RSA_user in the current using the following commands. > cd C:\Program Files\VMware\Infrastructure\SSOServer\utils > ssocli manage-secrets -a listallkeys [Enter Master password: ********] The output will show the passwords: Secrets stored Read More…
You must be logged in to post a comment.