Next.js Discord

Discord Forum

Connecting to Azure SQL from Vercel

Unanswered
Australian Freshwater Crocodile posted this in #help-forum
Open in Discord
Avatar
Australian Freshwater CrocodileOP
Has anybody figured out how to connect to an Azure SQL (MSSQL) database? I've got it working locally but am running into an issue with the firewall rules since Vercel uses dynamic IP addresses.

I've seen this guide for using Azure MySQL, but I haven't found a way to use that same SSL certificate approach with Azure SQL. It might be possible but I keep running into dead ends in the documentation.

2 Replies

Avatar
you need to upgrade the Vercel plan in order to get a static IP, so you can add it to the Azure firewall list. or have a proxy server in Azure.
Avatar
Australian Freshwater CrocodileOP
ahh, thanks!