single sign-on install

[BillysGruff]

Maybe its been discussed before but I'm confused.  I'm working in my test environment and am installing Single-Sign On.  I'm currently upgrading vCenter 5.0 to 5.1  I've ran both .sql scripts to create table spaces and insert the users.  Running netstat -a | find "1433" shows that SQL server is listening on that port.  When I put in the authentication information into the install window, and hit Next, it says the 'Database connection has failed'.  I'm confused.

[spravtek · Accepted solution]

Hi,

Did you make sure that the manually created users are using SQL Server authentication?

From the release notes:

Connection to the MSSQL database fails during vCenter Single Sign On installation
The error message Database connection has failed appears when  you install vCenter Single Sign On and you are using manually created  MSSQL database users. For MSSQL databases, you must use SQL Server  Authentication database users. Windows Authentication users are not  supported.

[BillysGruff]

Yes sir.  They are setup for SQL authentication only with the script that came with vCenter.  The users were setup for SQL authentication, but the database was Windows authentication only, not mixed, when I changed to mix mode, I was able to proceed to next step.  Yay.

[BillysGruff]

Ok, so I've got everything installed, setup for AD authentication.  How do I login?  It keeps telling me I dont have permission to login.

[spravtek]

Did you try to log in like this: username@domain.local

Besides that, is your domain the primary domain in SSO?