Forum Discussion
Azure Serverless SQL Server / Multiple DBs / Same Logical SQL Server
Hello all. I have this web app that uses a SQL database. There will be two environments for this app; stage and prod. I set up the web app for stage and then set up an Azure SQL Serverless database for the stage database. When you create that serverless SQL database, it also creates a logical SQL server for the database that you can then connect to with SSMS and and set things up. So I get the stage web/Sql app working. Now it's time to set up the prod web/db app. I create a new web app and then create another serverless SQL database. When I created the serverless prod database, I chose to create it on the same logical SQL server where the stage serverless database is at. As soon as i did that, the stage web app stops working because it's having database connection problems. I look in the staging website app service application logs and I see messages like this:
Only one usage of each socket address (protocol/network address/port) is normally permitted
An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full
Here's the question: Is it supported to have two SQL databases on the same serverless logical SQL server? Is a serverless logical SQL server only meant to manage one SQL database?
Any feedback appreciated. Thanks.