Forge Home

Modules

Puppet

Resources

PuppetEcosystemPuppet CommunityUpdates

sqlserver

The sqlserver module installs and manages MS SQL Server 2012 and 2014 on Windows systems.
Project URLRSS FeedReport issues

177,680 downloads

368 latest version

4.5 quality score

We run a couple of automated
scans to help you access a
module's quality. Each module is
given a score based on how well
the author has formatted their
code and documentation and
modules are also checked for
malware using VirusTotal.

Please note, the information below
is for guidance only and neither of
these methods should be considered
an endorsement by Puppet.

Version information

  • 5.0.2 (latest)
  • 5.0.1
  • 5.0.0
  • 4.1.0
  • 4.0.0
  • 3.3.0
  • 3.2.1
  • 3.2.0
  • 3.1.0
  • 3.0.0
  • 2.6.2
  • 2.6.1
  • 2.6.0
  • 2.5.1
  • 2.5.0
  • 2.4.0
  • 2.3.0
  • 2.2.0
  • 2.1.1
  • 2.1.0
  • 2.0.2
  • 2.0.1 (deleted)
  • 2.0.0
  • 1.2.0
  • 1.1.6
  • 1.1.5
  • 1.1.4
  • 1.1.3
  • 1.1.2
  • 1.1.1
  • 1.1.0
  • 1.0.0
  • 0.0.1
released Dec 11th 2014
This version is compatible with:
  • Puppet Enterprise 3.7.x

This module is licensed for use with Puppet Enterprise. You may also evaluate this module for up to 90 days.Learn More

Start using this module

  • r10k or Code Manager
  • Bolt
  • Manual installation
  • Direct download

Add this module to your Puppetfile:

mod 'puppetlabs-sqlserver', '0.0.1'
Learn more about managing modules with a Puppetfile

Add this module to your Bolt project:

bolt module add puppetlabs-sqlserver
Learn more about using this module with an existing project

Manually install this module globally with Puppet module tool:

puppet module install puppetlabs-sqlserver --version 0.0.1

Direct download is not typically how you would use a Puppet module to manage your infrastructure, but you may want to download the module in order to inspect the code.

Download
Tags: database, sql, mssql, microsoft, sqlserver, sql2014, tsql, sql2016, sql2017, sql2019, sql2022

Documentation

puppetlabs/sqlserver — version 0.0.1 Dec 11th 2014

sqlserver

The Puppet Supported Microsoft SQL Server module is coming soon, available later this December for Puppet Enterprise customers.

It will install and manage Microsoft SQL Server 2012 and 2014 on Windows systems.

The Puppet module will provide defined types to install and manage Microsoft SQL Server 2012 and 2014 on Windows Server 2012. It can install SQL Server clients, multiple instances, and SQL features, as well as create and manage new databases and logins.

For example, the following Puppet code installs MS SQL and creates an MS SQL instance named MSSQLSERVER. It installs the base SQL feature set (Data Quality, FullText, Replication, and SQLEngine), specifies the location of the setup.exe, and creates a new SQL-only sysadmin, 'myuser'.

sqlserver_instance {'MSSQLSERVER':
  features              => ['SQL'],
  source                => 'E:/',
  sql_sysadmin_accounts => ['myuser'],
}

Return to this module page later this month for the release or follow @puppetlabs on Twitter for notification. The 0.0.1 release you see here only contains this message.