database connection has failed vm-sso-javalib.log

[Beadmin]

Trying to upgrade vcenter 4.0 to 5.1,

trying to intsall signle sign on , created db and users using script, but getting error:

database connection has failed vm-sso-javalib.log

log have following error:

Initialize values of user DBA user RSA_DBA , other user RSA_user

[2013-04-14 15:19:46,169] INFO     5[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - DB information jdbcUrl:jdbc:sqlserver://;serverName=*******;port=1433;databaseName=RSA type: Mssql userName:RSA_DBA

[2013-04-14 15:19:46,635]ERROR   471[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.error(?:?) - Failed to established connection :com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'RSA_DBA'.

[2013-04-14 15:19:46,635] INFO   471[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - could not close JDBC connection

within SQl 2008 sp2 db all ports are already set to 1433, what next to be tried ?

[JCMorrissey]

Hi,

Take a look at the comments section in

http://www.derekseaman.com/2012/09/vmware-vcenter-51-installation-part-1.html

it mentions disabling encryption gets around this problem

[Beadmin]

Thanks,

SQL Authentication method was set to windows authentication only, changed it to mixed restart and boom.