error 29114 cannot connect to db during VCenter 5.1 SSO install

[gdwnet]

I'm attempting to install VCenter 5.1 (build 947939)  and I've selected the simple install and told the installer to use SQL 2008 express.

So, the install gets to a point where it generates the above error. The log shows:

RunSSOCommand:: error code returned is 14 while launching C:\Program Files\VMware\Infrastructure\SSOServer\utils\rsautil.cmd

According to http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=203631... this occurs when the SSO database RSA (default SSO DB name) does not meet the prerequisites for the SSO installation and the RSA DB table space RSA_INDEX has a filegroup type of PRIMARY, instead of RSA_INDEX.

Ok... Why is it occuring if the 'simple' installer is doing the installation of everything? Is that a bug in the installer and if so is it fixed or should I just give up using the incorrectly named simple installer?

Thanks.

[raog]

The workaround mentioned in the KB didnt work for you? Also did your machine already have SQL server express installed or is it getting installed via the SSO installer?

Regards

Girish

[gdwnet]

No it didn't work because I never had SQL installed. The 'simple' installer also installed SQL express.

[rwilliam]

If you have attempted the installation more than once, also un-install the Express MS SQL installation, thus removing all reference to SSO installation.

[gdwnet]

Yes, I did that and I still get the above error when using the 'simple' installer to do it all for me.

[gdwnet]

So, I've tried a few other things and still no joy. I've downloaded the latest version of the full install package, build 1123966 and still the same error.

The weird thing is that the vm-sso-javalib file says everything is fine:

[2013-05-30 18:15:54,104] INFO	0[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - IP stack is fine
[2013-05-30 18:15:54,104] INFO	0[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - IP Stack works
[2013-05-30 19:00:16,072] INFO	0[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - Validate database connection
[2013-05-30 19:00:16,087] INFO	15[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - DB information jdbcUrl:jdbc:sqlserver://;serverName=10.103.1.2;port=49260;databaseName=RSA type: Mssql
[2013-05-30 19:00:16,087] INFO	15[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - Initialize values of user DBA user RSA_DBA , other user RSA_SSO_USER_ACC
[2013-05-30 19:00:16,087] INFO	15[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - DB information jdbcUrl:jdbc:sqlserver://;serverName=10.103.1.2;port=49260;databaseName=RSA type: Mssql userName:RSA_DBA

[2013-05-30 19:00:19,379] INFO  3307[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - Executing query :SELECT prin.[name] [User], sec.state_desc + ' ' + sec.permission_name [Permission] FROM [sys].[database_permissions] sec JOIN [sys].[database_principals] prin ON sec.[grantee_principal_id] = prin.[principal_id] WHERE sec.class = 0 ORDER BY [User], [Permission];

[2013-05-30 19:00:19,394] INFO  3322[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - User dbo Permission GRANT CONNECT

[2013-05-30 19:00:19,394] INFO  3322[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - dbo permission exits

[2013-05-30 19:00:19,394] INFO  3322[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - User RSA_DBA Permission GRANT CONNECT

[2013-05-30 19:00:19,394] INFO  3322[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - User RSA_USER Permission GRANT CONNECT

[2013-05-30 19:00:19,394] INFO  3322[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - User RSA_USER Permission GRANT CONNECT

[2013-05-30 19:00:19,394] INFO  3322[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - dbo permission exits

[2013-05-30 19:00:19,394] INFO  3322[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - JDBC Connection was successfully closed

[2013-05-30 19:00:19,394] INFO  3322[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - DB information jdbcUrl:jdbc:sqlserver://;serverName=10.103.1.2;port=49260;databaseName=RSA type: Mssql userName:RSA_SSO_USER_ACC

[2013-05-30 19:00:19,425] INFO  3353[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - JDBC Connection was successfully closed

Yet the SSO installer log tells me that the connection to the DB isn't working:

Caused by: com.rsa.common.UnexpectedDataStoreException: Unexpected error adding certificate: Root CA Certificate

    Caused by: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [INSERT INTO IMS_CERTIFICATES (ID, ROW_VERSION, NAME, DESCRIPTION, PURPOSE, DATA, REF_ID, LAST_UPDATED_BY, LAST_UPDATED_ON) VALUES (?,?,?,?,?,?,?,?,?)]; Cannot open database "RSA" requested by the login. The login failed.; nested exception is java.sql.SQLException: Cannot open database "RSA" requested by the login. The login failed.

    Caused by: java.sql.SQLException: Cannot open database "RSA" requested by the login. The login failed.

    Caused by: java.sql.SQLException: Login failed for user 'RSA_USER'.

So how can it work for one and not the other? I checked out the filegroups and I've got them configured like this:

Any suggestions as to what I've missed?

Thanks.

[VC51]

WHat was the resolution to this??

CHeers.