Create/Update an MSSQL Server in Azure

Creates new Microsoft SQL Server in Azure

Requirements

Tested on ansible [core 2.13.1]

Install the Azure Collection from Galaxy:

• ansible-galaxy collection install azure.azcollection

Install the Python requirement packages from the collection

• sudo pip3 install -r ~/.ansible/collections/ansible_collections/azure/azcollection/requirements-azure.txt

Resource group must exists prior

Server Module Documentation: https://docs.ansible.com/ansible/latest/modules/azure_rm_sqlserver_module.html

Role Variables

Variables outside of script directly needed for formating:

#Default required
resource_group:
location: #Azure location

#SQL Database Options
sql_server: #Name of the SQL server you're creating or changing
sql_version: #Version of MSSQL Server

Dependencies

Example Playbook

---

- name: Create or Update an Azure SQL Server
  hosts: localhost
  pre_tasks:
    - name: Setting desired state
      set_fact:
        resource_group: testRG
        location: canadacentral
        sql_server: MyServer01
        sql_server_admin: myadminaccount
        sql_server_password: XXXXXXXXXXXX

  connection: local
  roles:
    - azure-sqlserver

License

MIT

Author Information

Adam Brassard: Abrass on IRC