Azure SQL server and DB deployement using ARM Template

Tejaswi Kandukuri 1

Is there any way to create SQL Server and Database along with the below requirements using ARM

Enabling the Audit on SQL server/ Database and diagnostic settings on SQL server and database
Setting Active Directory admin and Server admin
Create a private end point for the SQL server.
White list the main Subnets
Backups

I have tried by google, using those templates and all, but there is no luck. Please help me on this.

Ronen Ariely 15,191 Reputation points

2021-06-16T11:08:06.203+00:00

You can do it using PowerShell script for example

Search for each configuration that you want to do and you can find the commend -> combine it all to one script if needed
Tejaswi Kandukuri 1 Reputation point

2021-06-18T10:25:33.563+00:00

Sure i will try but if you have any thing available please help me.

1 answer

Sam Cogan 10,502 Reputation points MVP

2021-06-16T14:39:00.847+00:00
Yes, this is entirely possible with ARM templates. You can find a library of example ARM templates here, which include

Private Endpoints

SQL Server

You can also find the full ARM spec for SQL here along with any other resource.
Please sign in to rate this answer.
Tejaswi Kandukuri 1 Reputation point

2021-06-18T10:24:53.897+00:00

Hi Sam,

Thanks very much for your response and i have tried as you suggested but as i am very new to this ARM i am not understanding where and what is going on, so if possible could you please help me json files please so that i can try with them.

Thanks alot for your response.

Sam Cogan 10,502 Reputation points MVP

2021-06-22T08:50:41.577+00:00

The links I provided have JSON files with ARM examples in them, they should be enough to get you going. If you don't understand ARM yet then I recommend getting up to speed on that, I have a series of videos on this which will quickly get you up to speed here.

Saurabh Sharma 23,796 Reputation points Microsoft Employee

2021-06-24T23:35:03.34+00:00

Hi @Tejaswi Kandukuri ,

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Thanks
Saurabh

Saurabh Sharma 23,796 Reputation points Microsoft Employee

2021-06-29T16:07:20.247+00:00

Hi @Tejaswi Kandukuri ,

Please let me know if you find above reply useful. If yes, do click on 'Mark as answer' link in above reply. This will help other community members facing similar query to refer to this solution.

Thanks.
Saurabh
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure SQL server and DB deployement using ARM Template

1 answer

Your answer