robertdebock.mssql

Ansible Role MSSQL

THIS ROLE HAS BEEN ARCHIVED AS OF DEC 2023.

This role helps you install and set up MSSQL on your system.

GitHub	GitLab	Downloads	Version

Example Playbook

Here’s a simple example of how to use this role, which is tested on every change made:

---
- name: Converge
  hosts: all
  become: yes
  gather_facts: yes

  roles:
    - role: robertdebock.mssql

Before running this, your machine needs some setup. In CI, this is done with:

---
- name: Prepare
  hosts: all
  become: yes
  gather_facts: no

  roles:
    - role: robertdebock.bootstrap
    - role: robertdebock.core_dependencies
    - role: robertdebock.ca_certificates
    - role: robertdebock.microsoft_repository_keys

For more details, check out a full explanation and example on how to use these roles.

Role Variables

The default variable settings are in defaults/main.yml:

---
# defaults file for mssql

# Set to yes to install the necessary repositories.
mssql_add_repositories: yes

# Specify the MSSQL version, options are 2017 or 2019.
mssql_version: "2017"  # Only 2017 works at the moment.

# The version of server and server agent to install.
mssql_server_version: "14.0.3294.2-27"
mssql_server_agent_version: "14.0.3015.40-1"

# Password for the system administrator (minimum 8 characters, must include upper/lowercase letters, numbers, and symbols).
mssql_sa_password: "StR0nGp4ss."

# Product key options for MSSQL.
mssql_pid: Evaluation  # Alternatives: Developer, Express, Web, Standard, Enterprise, or a specific product key.

# Enable Full Text Search by setting this to yes.
mssql_fts: no