How to Set Up a Microsoft Entra ID SQL Server

To set up a Microsoft Entra ID SQL server:

1. Create a new subnet in a VNET that will be used specifically to access the SQL server.
2. Create the proxy VM, attach it to this subnet, and add a publicly accessible IP to it.
3. Enter the SQL Database config and click Set server firewall.
4. Add a Virtual Network rule allowing access to the server from the proxy’s subnet.

On the CloudGen Access Enterprise Console, create the proxy and the DB resource using the public domain name of the Microsoft Entra ID DB (from Microsoft Entra ID config) and port 1433.

Do not forget to use the same name for the public host in the resource as the one Microsoft Entra ID assigns. As an alternative, pass the domain name of the DB server in the username (for example, user@somedb.database.windows.net) while logging in.

Finally, you must change the SQL Server mode to Proxy mode, using the steps listed here. You need a CLI or PowerShell console to do so.