Help locating SSO database(5.1)

[drheim]

Hi guys,

I have (2)VMWare environments.  Both are 5.1u1.  One of the vCenter servers has a SQL 2008 database on it named RSA and I figured out that is the SSO database for that environment.  On the other vCenter server, I cannot find it.  I know it is using a different SSO server, and I looked through the database server and see the vcenter database and the update manager database for that environment, but not sure where the SSO database is.  Not seeing a DSN either for it and my guess is that it might not be SQL.  I tried to check some of the config files in the SSO directories, but do not see a database file or a config file that will tell me.  Does anyone know an easy way to see this?

Thanks,

Dan

[rh5592]

Try checking the SQL accounts in your DB server. The database mapped to the RSA_DBA and RSA_USER is your SSO database.

Or could it be that the other vCenter server used SQL Express inside of the vCenter Server itself?

[pratjain · Accepted solution]

You can check this file

C:\Program Files\VMware\Infrastructure\SSOServer\webapps\lookupservice\WEB-INF\classes\config.properties on the machine where SSO is installed.

This would provide you the details of the RSA database

[drheim]

Thanks for the help - It does look like SQL express