Ansible Role mssql

This role helps you install and set up Microsoft SQL Server (mssql) on your system.

GitHub	Version	Issues	Pull Requests	Downloads

Example Playbook

Here’s a simple playbook example from molecule/default/converge.yml, which is tested every time there’s an update.

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

  roles:
    - role: buluma.mssql

Before running, the machine needs some setup, which is done using molecule/default/prepare.yml:

---
- name: Prepare
  hosts: all
  gather_facts: false
  become: true

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

You can also check out a full explanation and example on using these roles.

Role Variables

Default variable values are set in defaults/main.yml:

---
# defaults file for mssql

# Use this to choose if you want the role to install repositories.
mssql_add_repositories: true

# Choose the version to install: currently only 2017 is fully supported.
mssql_version: "2017"

# Set 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"

# Set the password for SQL server administrator. It must be at least 8 characters long, 
# with characters from at least three of these four sets: 
# - uppercase letters
# - lowercase letters
# - numbers
# - symbols
mssql_sa_password: "StR0nGp4ss."

# Set the product key to use for installation. Options include:
# - Evaluation
# - Developer
# - Express
# - Web
# - Standard
# - Enterprise
# - A product key (Format: #####-#####-#####-#####-#####)
mssql_pid: Evaluation

# Set to true to enable full text search.
mssql_fts: false

Requirements

• Python packages listed in requirements.txt.

State of Used Roles

These roles help prepare your system:

Requirement	GitHub	Version
buluma.bootstrap
buluma.ca_certificates
buluma.core_dependencies
buluma.microsoft_repository_keys

Context

This role works with several other roles. Check out the documentation for these roles for more information.

Here’s a visual of related roles:

Compatibility

This role has been tested with the following container images:

You need at least Ansible version 2.12. Tests have been done on:

• The previous version.
• The current version.
• The development version.

If you find problems, please report them on GitHub.

Changelog

You can find the Role History here.

License

This project uses the Apache-2.0 license.

Author Information

Created by Shadow Walker.