SQL Server 2012 – Install Failed – SQLWriter Service Disabled

Background

Trying to install a named instance to a machine with a default installed, but failed.

 

Error Messages

Detail.txt

Image

Textual


(01) 2017-05-01 08:22:03 Slp: Sco: Returning service process id 1468
(01) 2017-05-01 08:22:03 SQLEngine: : Checking Engine checkpoint 'GetSqlServerProcessHandle_2'
(01) 2017-05-01 08:22:03 SQLEngine: --SqlServerServiceSCM: Waiting for nt event 'Global\sqlserverRecComplete$PERF' to be created
(01) 2017-05-01 08:22:04 SQLEngine: --SqlServerServiceSCM: Waiting for nt event 'Global\sqlserverRecComplete$PERF' or sql process handle to be signaled
(01) 2017-05-01 08:22:04 SQLEngine: : Checking Engine checkpoint 'WaitSqlServerStartEvents_1'
(01) 2017-05-01 08:22:04 SQLEngine: --SqlServerServiceSCM: Starting dependents of service 'MSSQL$PERF' in opposite order ...
(01) 2017-05-01 08:22:04 SQLEngine: Copying 'D:\Program Files\Microsoft SQL Server\MSSQL12.PERF\MSSQL\Log\ERRORLOG' to 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20170501_080639\SQLServer_ERRORLOG_2017-05-01T08.22.04.txt' ...
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to copy file 'D:\Program Files\Microsoft SQL Server\MSSQL12.PERF\MSSQL\Log\ERRORLOG' to file 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20170501_080639\SQLServer_ERRORLOG_2017-05-01T08.22.04.txt'
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to get security descriptor for file 'D:\Program Files\Microsoft SQL Server\MSSQL12.PERF\MSSQL\Log\ERRORLOG'
(01) 2017-05-01 08:22:04 Slp: Sco: Returning security descriptor O:S-1-5-80-1696324543-2353754024-1556012342-4066776139-377137144G:S-1-5-80-1696324543-2353754024-1556012342-4066776139-377137144D:AI(A;ID;FA;;;S-1-5-80-1696324543-2353754024-1556012342-4066776139-377137144)(A;ID;FA;;;SY)(A;ID;FA;;;BA)(A;ID;0x1201ff;;;S-1-5-80-2284653297-3842300192-3001888380-618865920-1741683089)
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to get files for directory D:\Program Files\Microsoft SQL Server\MSSQL12.PERF\MSSQL\Log, search pattern SQLDump*.mdmp
(01) 2017-05-01 08:22:04 SQLEngine: Copy '0' mdmp files from 'D:\Program Files\Microsoft SQL Server\MSSQL12.PERF\MSSQL\Log' to 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20170501_080639' ...
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to get files for directory D:\Program Files\Microsoft SQL Server\MSSQL12.PERF\MSSQL\Log, search pattern *.xel
(01) 2017-05-01 08:22:04 SQLEngine: "xel" file 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20170501_080639\system_health_0_131381257125540000_2017-05-01T08.21.52.xel' exists...
(01) 2017-05-01 08:22:04 Slp: Sco: File 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20170501_080639\system_health_0_131381257243270000_2017-05-01T08.22.04.xel' does not exist
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to copy file 'D:\Program Files\Microsoft SQL Server\MSSQL12.PERF\MSSQL\Log\system_health_0_131381257243270000.xel' to file 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20170501_080639\system_health_0_131381257243270000_2017-05-01T08.22.04.xel'
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to get security descriptor for file 'D:\Program Files\Microsoft SQL Server\MSSQL12.PERF\MSSQL\Log\system_health_0_131381257243270000.xel'
(01) 2017-05-01 08:22:04 Slp: Sco: Returning security descriptor O:S-1-5-80-1696324543-2353754024-1556012342-4066776139-377137144G:S-1-5-80-1696324543-2353754024-1556012342-4066776139-377137144D:AI(A;ID;FA;;;S-1-5-80-1696324543-2353754024-1556012342-4066776139-377137144)(A;ID;FA;;;SY)(A;ID;FA;;;BA)(A;ID;0x1201ff;;;S-1-5-80-2284653297-3842300192-3001888380-618865920-1741683089)
(01) 2017-05-01 08:22:04 SQLEngine: Copying 'D:\Program Files\Microsoft SQL Server\MSSQL12.PERF\MSSQL\Log\system_health_0_131381257243270000.xel' to 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20170501_080639\system_health_0_131381257243270000_2017-05-01T08.22.04.xel' ...
(01) 2017-05-01 08:22:04 SQLEngine: Copy '1' xel files from 'D:\Program Files\Microsoft SQL Server\MSSQL12.PERF\MSSQL\Log' to 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20170501_080639' ...
(01) 2017-05-01 08:22:04 SQLEngine: : SQLWriter: Enabling Writer SID before starting it.
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to set service sid type for service SQLWriter, serivce sid type SERVICE_SID_TYPE_UNRESTRICTED
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to open SC Manager
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to open service handle for service SQLWriter
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to close service handle for service SQLWriter
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to close SC Manager
(01) 2017-05-01 08:22:04 SQLEngine: : SQLWriter: Starting Writer Service.
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to start service SQLWriter
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to open SC Manager
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to open service handle for service SQLWriter
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to close service handle for service SQLWriter
(01) 2017-05-01 08:22:04 Slp: Sco: Attempting to close SC Manager
(01) 2017-05-01 08:22:04 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing Startup and scenario Startup.
(01) 2017-05-01 08:22:04 Slp: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.

(01) 2017-05-01 08:22:04 Slp: The configuration failure category of current exception is ConfigurationFailure
(01) 2017-05-01 08:22:04 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing Startup and scenario Startup.
(01) 2017-05-01 08:22:04 Slp: System.ComponentModel.Win32Exception: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
(01) 2017-05-01 08:22:04 Slp:    at Microsoft.SqlServer.Configuration.Sco.Service.StartService(String[] startParams)
(01) 2017-05-01 08:22:04 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SQLWriterStarter.NetStartSQLWriterService(ServiceContainer context)
(01) 2017-05-01 08:22:04 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
(01) 2017-05-01 08:22:04 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
(01) 2017-05-01 08:22:04 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
(01) 2017-05-01 08:22:04 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
(01) 2017-05-01 08:22:04 Slp: Inner exceptions are being indented
(01) 2017-05-01 08:22:04 Slp: 
(01) 2017-05-01 08:22:04 Slp: Exception type: System.ComponentModel.Win32Exception
(01) 2017-05-01 08:22:04 Slp:     Message: 
(01) 2017-05-01 08:22:04 Slp:         The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
(01) 2017-05-01 08:22:04 Slp:         
(01) 2017-05-01 08:22:04 Slp:     HResult : 0x80004005
(01) 2017-05-01 08:22:04 Slp:     Error : 1058
(01) 2017-05-01 08:22:04 Slp:     Data: 
(01) 2017-05-01 08:22:04 Slp:       SQL.Setup.FailureCategory = ConfigurationFailure
(01) 2017-05-01 08:22:04 Slp:       WatsonConfigActionData = INSTALL@STARTUP@SQL_ENGINE_CORE_INST
(01) 2017-05-01 08:22:04 Slp:       WatsonExceptionFeatureIdsActionData = System.String[]
(01) 2017-05-01 08:22:04 Slp:     Stack: 
(01) 2017-05-01 08:22:04 Slp:         at Microsoft.SqlServer.Configuration.Sco.Service.StartService(String[] startParams)
(01) 2017-05-01 08:22:04 Slp:         at Microsoft.SqlServer.Configuration.SqlEngine.SQLWriterStarter.NetStartSQLWriterService(ServiceContainer context)
(01) 2017-05-01 08:22:04 Slp:         at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
(01) 2017-05-01 08:22:04 Slp:         at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
(01) 2017-05-01 08:22:04 Slp:         at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
(01) 2017-05-01 08:22:04 Slp: Watson Bucket 1 
 Original Parameter Values 

(01) 2017-05-01 08:22:04 Slp: Parameter 0 : SQL Server 2014@RTM@ 

(01) 2017-05-01 08:22:04 Slp: Parameter 1 : Microsoft.SqlServer.Configuration.Sco.Service.StartService 

(01) 2017-05-01 08:22:04 Slp: Parameter 2 : Microsoft.SqlServer.Configuration.Sco.Service.StartService 

(01) 2017-05-01 08:22:04 Slp: Parameter 3 : System.ComponentModel.Win32Exception@-2147467259 

(01) 2017-05-01 08:22:04 Slp: Parameter 4 : System.ComponentModel.Win32Exception@-2147467259 

(01) 2017-05-01 08:22:04 Slp: Parameter 5 : SqlEngineConfigAction_install_startup 

(01) 2017-05-01 08:22:04 Slp: Parameter 6 : INSTALL@STARTUP@SQL_ENGINE_CORE_INST 

Explanation

  1. Unable to start the SQLWriter service

 

Trouble Shooting

Services

Explanation

  1. The SQL Server VSS Writer is disabled

 

Microsoft Connect

    • Connect Item :- 3133317
    • Link :- Link
    • Date :- 2017-May-1st
    • Status :- Active
    • Type :- Suggestion

Summary

From an earlier troubleshooting session, we had disabled the SQL Server VSS Writer service.

The Install still went well.  And, the only problem is that the installer was unable to start the disabled service.

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s