Domain Discovery with SSO

If domains are manually added after SSO is set up and SSO does not auto discover the domains, use the following steps to manually auto discover without using the vSphere Web Client.
Run the ssocli utility. It is located at %ProgramFiles%VMwareInfrastructureSSOServerutils
Open up command prompt, change the directory to the one specified above.
Run the following command:
ssocli configure-riat –verbose –a discover-is –u admin –p <sso password>

Error while installing SSO for vCenter 5.1

While installing Single Sign On (SSO) as a part of vSphere 5.1 for a recent consulting gig, I ran into a new issue.

After entering the database information, the installer returned an error that stated “Error 29114. Cannot connect to DB.” The first thing that I checked was the database itself. I made sure that I had entered the host information and the database name “RSA” correctly. I then verified that the “RSA_USER” and the “RSA_DBA” accounts had the corrected permissions as stated by the vSphere 5.1 Installation Guide. The next thing that I checked was the ODBC connection to make sure that it was successful and everything was entered correctly.

After a little bit of research and running “netstat”, I decided to check the SQL Server Configuration Manager to verify that the TCP Port used for the Database matched what the installer was using. BEHOLD! It did not, it was using the default of dynamic TCP ports. Once I changed the TCP Port under the SQL Server Network Configuration to 1433 and tried to run the installer again I was successful.