Forge Home

mssql

Puppet Labs Microsoft SQL Server Module

174,245 downloads

160,373 latest version

3.6 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

  • 0.2.1 (latest)
  • 0.2.0
  • 0.1.0
released Feb 5th 2015
This module has been deprecated by its author since Feb 1st 2021.

The author has suggested puppetlabs-sqlserver as its replacement.

Start using this module

Documentation

puppetlabs/mssql — version 0.2.1 Feb 5th 2015

#mssql

This module installs Microsoft SQL Server 2008R2 on Windows 2008R2.

Installation

This module depends on DISM module to enable .net 3.5 on Windows Server:

Configuration

The installer support the following options:

media          = 'D:\\',
instancename   = 'MSSQLSERVER',
features       = 'SQL,AS,RS,IS',
agtsvcaccount  = 'SQLAGTSVC',
agtsvcpassword = 'sqlagtsvc2008demo',
assvcaccount   = 'SQLASSVC',
assvcpassword  = 'sqlassvc2008demo',
rssvcaccount   = 'SQLRSSVC',
rssvcpassword  = 'sqlrssvc2008demo',
sqlsvcaccount  = 'SQLSVC',
sqlsvcpassword = 'sqlsvc2008demo',
instancedir    = "C:\\Program Files\\Microsoft SQL Server",
ascollation    = 'Latin1_General_CI_AS',
sqlcollation   = 'SQL_Latin1_General_CP1_CI_AS',
admin          = 'Administrator'

See http://msdn.microsoft.com/en-us/library/ms144259.aspx for more information about these options.