En la instalación de vCenter Single Sign On (SSO), nos hemos encontrado un error un tanto curioso al hacer la conexión con la base de datos e introducir usuario DBA y USER.
Dicho error es el de la imagen:
1 |
Database connection has failed. You can refer to the vm-sso-javaLib.log in the system temporary folder for more information. |
Al observar el log, puedes ver que hay un problema con la conexión.
En este caso, estábamos utilizando un Windows 2008 R2 hacia un MSSQL 2005.
LOG (vm-sso-javaLib.log):
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
[2013-03-14 12:00:02,561] INFO 0[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - Validate database connection [2013-03-14 12:00:02,561] INFO 0[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - DB information jdbcUrl:jdbc:sqlserver://;serverName=SERVER;port=1433;databaseName=sso01 type: Mssql [2013-03-14 12:00:02,561] INFO 0[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - Initialize values of user DBA user sso_dba , other user sso_user [2013-03-14 12:00:02,577] INFO 16[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - DB information jdbcUrl:jdbc:sqlserver://;serverName=SERVER;port=1433;databaseName=sso01 type: Mssql userName:sso_dba [2013-03-14 12:00:03,591] INFO 1030[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-03-14 12:00:03,607] INFO 1046[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - User dbo Permission GRANT CONNECT [2013-03-14 12:00:03,607] INFO 1046[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - dbo permission exits [2013-03-14 12:00:03,607] INFO 1046[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - User sso_dba Permission GRANT CONNECT [2013-03-14 12:00:03,607] INFO 1046[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - User sso_user Permission GRANT CONNECT [2013-03-14 12:00:03,607] INFO 1046[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - dbo permission exits [2013-03-14 12:00:03,607] INFO 1046[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - JDBC Connection was successfully closed [2013-03-14 12:00:03,607] INFO 1046[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - DB information jdbcUrl:jdbc:sqlserver://;serverName=SERVER;port=1433;databaseName=sso01 type: Mssql userName:sso_user [2013-03-14 12:00:03,778]ERROR 1217[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.error(?:?) - Failed to established connection :com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sso_user'. [2013-03-14 12:00:03,778] INFO 1217[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - JDBC Connection was successfully closed |
SOLUCIÓN:
El error tiene que ver con que la contraseña asignada contiene una barra “\”. Después de modificar la contraseña del usuario de la base de datos, ha funcionado sin problemas.
Te ha gustado la entrada SGUENOS EN TWITTER O INVITANOS A UN CAFE?