vCenter Single Sign-On and its database preparation

For deployment of vSphere SSO, you need to have a database prepared for it. This database can be bundled or can be custom too. If you are considering a bundled SQL Server 2008, then Mixed Mode Authentication is required for that database. So, if you already have a bundled database and are using Windows Authentication mode, then you need to change it to Mixed Mode Authentication.

Now, if you are considering external database (custom) then you do not need ODBC/DSN, rather the SSO installer constructs the JDBC information from the screen input.

The SSO database should be created manually and the scripts to do it are available in InstallerMedia\Single Sign-On\DBScripts\SSOServer\schema. You can find different folders there for different supported databases. The name of the database script located at the above mentioned directory is rsaIMSLite<database>SetupTablespaces.sql (Replace <database> with Oracle, DB2, or MSSQL).

Only tablespaces...