Tuesday, May 20, 2014

vCenter / Simple install errors when using SQL Server

Error: Database connection has failed.  You can refer to the vm-sso-javaLib.log in the system temporary folder for more information.

You may get the above error when you fill in details on "Database Information" screen and click on next



Issue is actually with the Single Sign On Database. Installer is expecting a database to be present with few table structures in it. It is stated in the instillation wizard if you go one step back!

So what you need to do is
1) do to the install location (DVD or the local copy)
2) Navigate to Single Sign On\DBScripts\SSOServer\schema\mssql (or to the right database folder if you are using databases other than SQL)
3) SKIP THIS STEP IF SQL IS INSTALLED ON THE SAME SERVER === Copy files "rsaIMSLiteMSSQLSetupTablespaces.sql" and 
"rsaIMSLiteMSSQLSetupUsers.sql" to the server running SQL Database4) Open "SQL Management Studio"
5) Double Click and open 
"rsaIMSLiteMSSQLSetupTablespaces.sql". It will get opened in SQL Management Studio.
6) Edit the file location for .mdf and .ldf file locations and execute the script.
7) Once completed, open 
"rsaIMSLiteMSSQLSetupUsers.sql" the same way8) Edit Passwords (better to keep the user names default as RSA_USER and RSA_DBA, just change the passwors) and execute this one too.

Once this two steps are completed,  the SSO installation should be able to proceed without any issues.

===========================================================

Error: The specified user does not have sufficient privileges.  Refer to Installation and Setup guide for more details on the privilege requirements.


Take a close look at the configurations and makesure that you haven't swapped DataBase User and DataBase DBA User credentials! :)