how to define to use existing database server in ARM template?

Question

Tuning the quick start, helps me deploy the App and DB. The thing I noticed was each time, my ARM template dictate to create a new DB server and load database. The tricky thing is that subscription got a limit of 6 DB servers.

Is there a way, I could define this as a configuration parameter and ARM template uses this db server than creating new one?

Error Message I get in shell console is :
>New-AzureRmResourceGroupDeployment : Resource Microsoft.Sql/servers 
>'sqlserverXXXXXt6fXX' failed with message 'Cannot move or create server. 
>Subscription '123XXXXXXXXXXXXXXXXXXe5X' will exceed server quota.'

Any suggestion or pointers would be great help!

Thanks

H Bala

Hi Gaurav, I just figured out a way and I have posted it below. It would be great to know your view or any alternative! Thanks! — H Bala
– H Bala, Commented May 18, 2016 at 11:08

H Bala · Accepted Answer · 2016-05-18 11:07:23Z

3

My bad! This could be done with setting the servername variable to existing database server name and letting it be fixed always.

"resources": [
{
  "name": "[variables('sqlserverName')]",
  "type": "Microsoft.Sql/servers",
  "location": "[resourceGroup().location]",
  "tags": {
    "displayName": "SqlServer"

to

"resources": [
    {
     "name": "{**sqldbservername_desired**}",
     "type": "Microsoft.Sql/servers",
     "location": "[resourceGroup().location]",
     "tags": {
       "displayName": "SqlServer"

Thanks & Regards,

H Bala

answered May 18, 2016 at 11:07

H Bala

1,3212 gold badges14 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to define to use existing database server in ARM template?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related