Can I setup an SQL Server on Virtual Machine via a json script

Peschlow 20 Reputation points
2024-05-23T18:50:56.6566667+00:00

Hello,

I tried to setup a vitual machine together with sql server multiple times,

but everytime there was finally any problem with SQL Iaas Extension and/or SQL Server,

so the VM is running, but no SQL Server,

Currently I am in the validation phase of 30d and hope, that this is not the reason for these errors,

So I wondering, whether someone has a json script to setup such a SQL Server on VM in azure cloud,

I have seen a video, that such option does exist to avoid too much clicking through all the menus,

Can you help me with such a script?

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,134 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,014 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,165 questions
{count} votes

Accepted answer
  1. Vahid Ghafarpour 22,065 Reputation points
    2024-05-23T19:21:47.7033333+00:00

    Thanks for posting your question in the Microsoft Q&A forum.

    Setting up a SQL Server on an Azure Virtual Machine (VM) using an ARM (Azure Resource Manager) template is a great way to automate the process and avoid manual configuration.

    https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/create-sql-vm-resource-manager-template?view=azuresql&tabs=CLI

    ** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.