question

TejaswiKandukuri-0626 avatar image
0 Votes"
TejaswiKandukuri-0626 asked SaurabhSharma-msft commented

Azure SQL server and DB deployement using ARM Template


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.

azure-sql-database
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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

0 Votes 0 ·

1 Answer

Sam-Cogan avatar image
0 Votes"
Sam-Cogan answered SaurabhSharma-msft commented

Yes, this is entirely possible with ARM templates. You can find a library of example ARM templates here, which include

You can also find the full ARM spec for SQL here along with any other resource.


· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·
Sam-Cogan avatar image Sam-Cogan TejaswiKandukuri-0626 ·

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.


0 Votes 0 ·

Hi @TejaswiKandukuri-0626,

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


Thanks
Saurabh

0 Votes 0 ·
Show more comments