Microsoft SQL Server Connectivity

Queries and Resources
1

  • Goal: Connect to MS SQL Server from Retool without a username and password.

  • Steps: We were able to connect using the SSL/TLS option, but that also requires the username password.

  • Details: We are checking to see if there is an option to connect to MS SQL Server using single sign on. Want to avoid specifying the username/pwd.

1 Like
2

Hello @subbuiyer!

Unfortunately in Retool it is not possible to connect to a MS SQL Server without a username and password due to security constraints.

After doing some searching around online, the only options I were able to find were Azure Managed Identity (in Azure SQL Database), using SSO via Kerberos Authentication and Trusted Third-Party Authentication (OAuth, Azure AD).

These might be able to work for your use case but they fall outside of the domain of Retool. Are you not able to provide the username and password to the DB Resource? You would only need to validate the resource via the auth option you select on page load and when the auth token expires.