MSSQL Server 2012

[Jon Mosco]

I am using the MSSQL server module from puppet as a baseline for the installation of SQL Server 2012, and am running into issues durring the install.  It gets a lot of the way done, and issues this error:

Error: \\puppet\installs\SQLServer2012SP1\setup.exe /CONFIGURATIONFILE=C:\sql201

2.config.ini returned 194 instead of one of [0]

Error: /Stage[main]/Erp_db2012::Mssql_2012/Exec[install_mssql2012]/returns: chan

ge from notrun to 0 failed: \\puppet\installs\SQLServer2012SP1\setup.exe /CONFIG

URATIONFILE=C:\sql2012.config.ini returned 194 instead of one of [0]

Notice: Finished catalog run in 1933.62 seconds

Press any key to continue . . .

The module I wrote looks like this:

class db2012::mssql_2012 {

  file { 'C:\sql2012.config.ini':

    #    content => template('db2012/config_2012.ini.erb'),

    ensure       => present,

    source       => "puppet:///modules/erp_db2012/2012ConfigurationFile.ini",

  }

  exec { 'install_mssql2012':

    #command     => "\\\puppet\installs\SQLServer2012SP1\\setup.exe /Action=Install /IACCEPTSQLSERVERLICENSETERMS /QS /CONFIGURATIONFILE=C:\\sql2012.config.ini",

    command      => "\\\puppet\installs\SQLServer2012SP1\\setup.exe /CONFIGURATIONFILE=C:\\sql2012.config.ini",

    logoutput    => true,

    creates      => "C:\\Program Files\\Mirosoft SQL Server",

    #    timeout => 1200,

    timeout      => 0,

    #returns      => 3,

    require      => File ['C:\sql2012.config.ini'],

    #Dism['NetFx3'] ],

  }

}

I can try to add the return codes, but I am not sure if this is a solid fix.

[Helen]

Hi,

I managed to get SQL server 2008 R2 install with puppet by using the
puppet windows_package module


https://forge.puppetlabs.com/reidmv/windows_package
(now builtin to puppet 3.4.2 )




class windows_package {

windows_package { 'Microsoft SQL Server 2008 R2 (64-bit)':
ensure => installed,
source => '\\myfileserver\Install\SQL Server 2008 R2
\Developer Edition with SP2\setup.exe',
install_options =>
['/q', '/SAPWD="password"', '/configurationfile=\\myfileserver\Install\SQL
Server 2008 R2\Developer Edition with SP2\ConfigurationFile.ini'],


}
}


This installs succesfully, but i need to add the reboot module as SQL
won't install if the machine is pending a reboot.

I would also like to test the new exit code in the later version of sql.




Thanks

Helen