Re: [Puppet Users] MSSQL Server 2012

[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





-- 
You received this message because you are subscribed to the Google Groups 
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to puppet-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/puppet-users/loom.20140116T150544-989%40post.gmane.org.
For more options, visit https://groups.google.com/groups/opt_out.

[Puppet Users] 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.

-- 
You received this message because you are subscribed to the Google Groups 
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to puppet-users+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-users@googlegroups.com.
Visit this group at http://groups.google.com/group/puppet-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.