The MSSQL SSO Server allows users to access SQL Server databases through SQL Server Management Studio without the password ever being on their machine.
Steps in implementing this for MSSQL SSO Server
- Ensure this function is turned on the Password Server
- Click on SSO Server
- Click on SSO Status
- Switch on the MSSQL SSO Server by click on MSSQL SSO Server and turning it on.
Follow these steps for further setup as documented in the link below. (I did not implement this functionality further as it wasn’t applicable to me because I was using username and password to access our database instances. https://info.pleasantsolutions.com/Documentation/Pleasant_Password_Server/H._Proxy_Server/MSSQL_SSO_Server
This was not resolved because connection seems to work but the authentication method I tried to use is not supported by the database instances and therefore did not work. I was trying to connect using Domain Account and this was not supported.