Installing SQLSERVER 2008 R2 on a windows 2008r2 machine

Hi Chef community,

I am trying to install the MSSQLSERVER 2008 R2 on windows machine 2008 R2. I am using the chef community cookbook “sql_server” version 2.6.1. I have reached a point where the package is getting copied and trying to install and failes with the below error. Could any one throw some light on the error please?

Error log

  • windows_service[MSSQLSERVER] action start[2016-05-23T16:57:41+05:30] INFO: Processing windows_service[MSSQLSERVER] a
    ction start (sql_server::server line 122)

    ?[0m

    Error executing action start on resource ‘windows_service[MSSQLSERVER]’

    SystemCallError

    The specified service does not exist as an installed service. - OpenService: The specified service does not exist as
    an installed service.

    Resource Declaration:

    In c:/chef/cache/cookbooks/sql_server/recipes/server.rb

    122: service service_name do
    123: action [:start, :enable]
    124: restart_command %(powershell.exe -C “restart-service ‘#{service_name}’ -force”)
    125: end
    126:

    Compiled Resource:

    Declared in c:/chef/cache/cookbooks/sql_server/recipes/server.rb:122:in `from_file’

    windows_service(“MSSQLSERVER”) do
    action [:start, :enable]
    supports {:restart=>nil, :reload=>nil, :status=>nil}
    retries 0
    retry_delay 2
    default_guard_interpreter :default
    service_name "MSSQLSERVER"
    pattern "MSSQLSERVER"
    restart_command "powershell.exe -C “restart-service ‘MSSQLSERVER’ -force”"
    startup_type :automatic
    declared_type :service
    cookbook_name "sql_server"
    recipe_name "server"
    end

    Platform:

    x64-mingw32

[2016-05-23T16:57:41+05:30] INFO: Running queued delayed notifications before re-raising exception
[2016-05-23T16:57:41+05:30] INFO: windows_package[r2-standardexeformat.exe] sending request_reboot action to reboot[sql
server install] (delayed)

  • reboot[sql server install] action request_reboot[2016-05-23T16:57:41+05:30] INFO: Processing reboot[sql server insta
    ll] action request_reboot (sql_server::server line 128)
    [2016-05-23T16:57:41+05:30] WARN: Reboot requested:‘sql server install’
    [2016-05-23T16:57:41+05:30] INFO: Changing reboot status from {} to {:delay_mins=>0, :reason=>“Needs to reboot after ins
    talling SQL Server”, :timestamp=>2016-05-23 16:57:41 +0530, :requested_by=>“sql server install”}

    • request a system reboot to occur if the run succeeds
      ?[0m
      Running handlers:
      [2016-05-23T16:57:41+05:30] ERROR: Running exception handlers
      Running handlers complete
      [2016-05-23T16:57:41+05:30] ERROR: Exception handlers complete
      Chef Client failed. 3 resources updated in 48 seconds
      [2016-05-23T16:57:41+05:30] INFO: Sending resource update report (run-id: fc54bb2f-3c2f-494e-99ed-85a54f8e92a4)
      [2016-05-23T16:57:42+05:30] FATAL: Stacktrace dumped to c:/chef/cache/chef-stacktrace.out
      [2016-05-23T16:57:42+05:30] FATAL: Please provide the contents of the stacktrace.out file if you file a bug report
      [2016-05-23T16:57:42+05:30] FATAL: SystemCallError: windows_service[MSSQLSERVER] (sql_server::server line 122) had an er
      ror: SystemCallError: The specified service does not exist as an installed service. - OpenService: The specified service
      does not exist as an installed service.
      PS C:\opscode\chef\bin>