Pleasant Password MS-MSQL SSO

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s