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"
endPlatform:
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>
- request a system reboot to occur if the run succeeds