Azure Web App unable to access Azure SQL Server

Question

My Azure web app crashes on startup when trying to connect to Azure SQL. This is a blazor web app, the azure sql server firewall is not allowing traffic through from the web app. I find the web app ip ranges, add them to firewall exceptions on the sql side, and it works until I redeploy the app. How can I give my Web app permanent access to the azure SQL server? I thought checking the box for 'Allow azure services and resources to access this server' would work, but it seems to do nothing AFAIK. The connection string the web app uses is in the format:

Server=tcp:xxxx.database.windows.net,1433;Initial Catalog=xxxx;Persist Security Info=False;User ID=xxxxx;Password=xxxxxx;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;