This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 24%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hi, I cannot find the answer to my following question. Is it posible to share 1 Azure SQL Elastic pool between several Recource groups?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Please check the below snapshot from this document which gives the indication about the answer to your question.
So as the document says you can't have cross server Databases on a Elastic Pool. So having Elastic pool with Databases from different Resource Group is also not possible.
Please get back to us for any questions.
Thanks
Navtej S
That is bad news, for me.
What would you advise for the following situtaion?
I have several Recources Group that have (need) a combination of resources like VM, Web app and SQL database.
My initial idee was to create 1 large Elastic Pool where the database of these VM's and Web app reside, but this is apparently not posible.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 13%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Depending on your needs, I would consider creating a resource group dedicated to shared/communal resources, and creating a SQL server there where you have a single pool with the various databases you need. I would strongly advise using database scoped credentials in this case, to constrain the apps to their respective databases.
The downside of this is I don’t believe you can evaluate the cost of the individual databases in the pool.
Also please raise the feedback here - https://feedback.azure.com/forums/217321-sql-database so that our team can check the same and take action regarding this.
Regards
Navtej S
Hi.
There is no requirement that the resources for a specific application (VM, Web App and Database) all have to be in the same resource group. You can mix these as you need.
Also, be certain that an Elastic Pool will actually meet your needs. The databases that you want to add to the Pool should all have an intermittent usage pattern with occasional burst of activity - see the description here
If are simply looking to reduce costs, then you need to: