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 clicking on MSSQL SSO Server and turning it on.
How to configure Pleasant Password
Follow these steps for further setup as documented in the link. (I did not implement this functionality further as it didn’t apply to me because I was using a username and password to access our database instances.
This was not resolved because the connection seemed to work, but the database instances did not support the authentication method I tried to use and, therefore, did not work. I was trying to connect using a Domain Account, which was not supported.
I hope you found this blog post on How to configure Pleasant Password helpful. Please let me know in the comment session if you have any questions.