Ask Your Question
0

How to configure Puppet to install SQL 2012?

asked 2013-08-16 10:15:33 -0500

WBClark gravatar image

I need the Puppet scripts to provision a Database and Application Server. That's including configure classes. Components to include Server Components ( Datebase engine & Reporting Services). The Management Tools to include (SQL Server Management Studio, SQL Server Profiler. Tuning Advisor, Data Tools, and Connectivity Components). Using SQL Server 2012 SP1 and Telnet cap.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2013-08-16 12:51:09 -0500

louis gravatar image

Hope this helps.

init.pp

class sqlexpress2008{

  $pkg      = 'sqlexpress2008R2'
  $cfg      = 'sqlexpressconfig'
  $features = 'SQLENGINE'

  file { $pkg:
    ensure => present,
    name   => 'C:\Temp\SQLEXPRWT_x64_ENU.exe',
    source => 'puppet:///puppetfs/SQLEXPRWT_x64_ENU.exe',
    mode   => '0755'
  }

  file { $cfg:
    ensure  => present,
    name    => 'C:\Temp\setup.ini',
    content => template('sqlexpress2008/setup.erb'),
    mode    => '0755'
  }

  exec { $pkg:
    creates => 'C:\Program Files\Microsoft SQL Server\100\Tools\Binn',
    command => 'cmd.exe /c C:\Temp\SQLEXPRWT_x64_ENU.exe /ConfigurationFile=C:\Temp\setup.ini',
    require => [File[$pkg],File[$cfg]],
    timeout => 1200
  }
}

setup.erb

;SQLSERVER2008 Configuration File
;SQLSERVER2008 Configuration File
[SQLSERVER2008]

; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required ...
(more)
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2013-08-16 10:15:33 -0500

Seen: 1,179 times

Last updated: Aug 16 '13