VMware Cloud Community
BillysGruff
Contributor
Contributor
Jump to solution

single sign-on install

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.

0 Kudos
1 Solution

Accepted Solutions
spravtek
Expert
Expert
Jump to 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.

View solution in original post

0 Kudos
4 Replies
spravtek
Expert
Expert
Jump to 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.

0 Kudos
BillysGruff
Contributor
Contributor
Jump to solution

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.

0 Kudos
BillysGruff
Contributor
Contributor
Jump to solution

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.

0 Kudos
spravtek
Expert
Expert
Jump to solution

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

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

0 Kudos