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. (I did not implement this functionality further as it wasn’t applicable to me because I was using a username and password to access our database instances.
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.
I hope you found this blog post helpful. If you have any questions, please let me know in the comment session.