Migrate vCenter database to new SQL server

migrate procedure kb link: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=7960893

ps. use the same sql account and password as same as old

If you move the SSO database from one SQL host to another host you need to update the SSO configuration with the new SQL server host information
Note: By default the permissions do not exist on the SQL server and, after the database is moved, the RSA_USER and RSA_DBA need to be created. See the vSphere Installation and Setup guide located at vSphere Installation and Setup Guide.

Note: On the server where SSO is installed, you can also view the jndi.properties file in the default location (C:\Program Files\VMware\Infrastructure\SSOServer\webapps\ims\web-inf\classes\) to see the database configuration for the SSO server and verify the values which need to be updated.
Most commonly these values are:

• com.rsa.db.hostname

• com.rsa.instanceName

On the server where SSO is installed, edit the file C:\Program Files\VMware\Infrastructure\SSOServer\webapps\lookupservice\WEB-INF\classes\config.propertiesand modify all values that need to be updated. Most commonly this is the value under:
## DB host

• Windows 2008 –  C:\ProgramData\VMware\VMware VirtualCenter\

To modify the location of the database settings for the Tomcat server:

1. Open the dabase_name.properties file using a text editor.
2. Locate this entry:
   
   url=jdbc:sqlserver://DB_hostname\\DB_instance;databaseName\=database_name;integratedSecurity\=true
   
3. Modify the required fields to match the new host name and the location of the database.
4. Restart the VMware VirtualCenter Management Webservices service in Windows or reboot the vCenter Server machine.