Step 3. Enable Single Sign-On (SSO) Authentication

Updated by Charlotte Stragier


Follow the steps below to complete the configuration and test the new login method using Single Sign-On (SSO).

  1.  In the Windows search bar, type Registry Editor and open this application. (NL: Register-editor / FR: Éditeur du Registre) and open this application.

Tip: you can also type “regedit” in the Start menu or Windows search bar to quickly find the app.

  1.  Navigate to the following registry path if the ODBC installation was performed using the default settings as described above: Computer\HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\SDWINSCLOUD (see printscreen below)
  2.  Select the SDWINSCLOUD data source by clicking on it. Its parameters will appear in the right-hand pane.
  3.  Add a new parameter:
    1. From the top menu, choose Edit → New → String Value.
    2. Name the new string value: singleAuthenticationPrompt
    3. Double-click the newly created entry and set its value to: true
    4. Click OK to confirm.
  4. Add a second parameter:
    1. From the top menu, choose Edit → New → String Value.
    2. Name the new string value: CLIENT_SESSION_KEEP_ALIVE
    3. Double-click the newly created entry and set its value to: true
    4. Click OK to confirm.

  1. Close the Registry Editor and return to the ODBC Data Source Administrator.
  2.  Select the SDWINSCLOUD system data source and click Configure.
  3.  Click Test to verify the connection. 

  1. A web browser window will open and redirect you to log in to Snowflake using mysdworx SSO.
  2. After a successful login, the test will complete and a success message will be displayed.

Any feedback?