Cannot log in to GPOADmin after upgrading to 5.16 - A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that i (4252979)
Cannot log in to GPOADmin after upgrading to 5.16 - A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that i
説明
After upgrading to 5.16, you cannot log in to the GPOADmin console. It either just does not connect, the console closes with no error or you receive the following error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
The above error can also be seen in the GPOADmin event logs when the service restarts.
原因
Mismatched SSL information on the SQL server.
対策
When the SQL Server is configured to "Force Encryption" and does not have a fully trusted certificate implemented, you can see this error.
On the SQL Server hosting the GPOADmin configuration database: Open SQL Server Configuration Manager, expand "SQL Server Network Configuration", right-click "Protocols for <instance>" > Properties. On the first tab, change "Force Encryption" to "No". Restart the SQL Server services, and then restart the GPOADmin services.
Confirm the following registry value on the GPOADmin server is also set to 0. HKLM\Software\Quest\GPOADmin\VCConfig\Encrypted