Forum Discussion

J_Bush's avatar
J_Bush
Copper Contributor
Mar 25, 2022

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. 

No RepliesBe the first to reply

Resources