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.

 

Active Directory – Change User’s Password – Erroring

 

Preface

This is a difficult post as it does not demonstrate a remedying process.

It merely demonstrates a stumbling block, we ran into as we tried to change an Active Directory Service Account’s password.

BTW, a couple of choices for changing an AD’s Account password are documented here.

 

Changing AD User Password : Attempting

UI

Active Directory Users & Managers

Reset Password

resetpassword

 

Reset Password – Access is Denied

accessisdenied

 

Console

dsmod

Tried to change password using dsmod

Batch File


@echo off

Rem Change a domain account’s password from the command line	
Rem https://itnsomnia.wordpress.com/2008/04/08/change-a-domain-accounts-password-from-the-command-line/

set "_SAMAccountName=SQLSvc"
set "_ADPassword=antelopeWASBEFOREME#"

echo ADUser
dsquery user -samid %_SAMAccountName%

dsquery user -samid %_SAMAccountName%  | dsmod user  -mustchpwd no -pwd %_ADPassword%

Echo ERRORLEVEL is %ERRORLEVEL%



Output


ADUser
"CN=MSSQLsql,OU=ServiceAccounts,OU=LAB,DC=AD"
dsmod failed:CN=MSSQLsql,OU=ServiceAccounts,OU=LAB,DC=AD:Access is denied.:Set password failed
type dsmod /? for help.
ERRORLEVEL is -2147467259
>

 

 

Diagnostic

Active Directory Users And Computers

User’s Properties

Per-using Active Directory Users and Computer, here is the AD Account’s setting:

accountproperties-account

 

Explanation

  1. User must change password at next logon
    • Set
      • Good
  2. User cannot change change password
    • Not Set
      • Good
  3. Password never expires
    • Set
      • Good

Conclusion

From a simple User Property review, nothing should stop this Service Account from changing its own password.

In a follow-up post, will review whether restrictions have been set at the Organization (ou) level.

 

Microsoft – SQL Server – v 2008-R2 – Service Pack 1 (SP1) – Upgrade fails “silently”

Microsoft – SQL Server – v 2008-R2 – Service Pack 1 (SP1) – Upgrade fails Silently

Trying to install “Microsoft SQL Server – v2008/R2” Service Pack 1 (SP1) fails.

Yes, upgrade are apt to fail sometimes, but this time, it is failing miserably.

What do I mean miserable; well:

  • Upon extraction of the compressed exe update file, the application simply shuts down.
  • No error messages
  • Nothing useful in the Event Log
  • Tweak “Local Policy” to enable logging of failures
  • Tried SysInternal’s “ProcessMonitor”

Nothing.  It is pulling the Great Houdini.  What to do, when things go bye bye, without a word.

Well Google of course.  But for what; what is my foe.  Every story needs a foe…

So brought the old notepad editor and created a little command file:


SQLServer2008R2SP1-KB2528583-x64-ENU.exe
echo ErrorLevel is %errorlevel%

Subconsciously, I know that if I am able to capture the error number, I will be able to get a bit of help from the “Oracle” of “Problem and Resolution Engine”, Google.

So run the command file and was able to get our Error Number:

-2147467259

Having en error number meant that in time we might get somewhere. Flirted with calling MS Support.

Went to Sleep over it. Hoping that a good night sleep and a rested mind will do a bit of good.

Googled for “2147467259 sql server setup.exe”

And, the most helpful link led to

1) SQL Server Express 2008 Setup Error : Exit code -2147467259.
http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/457b4874-3e8d-421a-a6e5-19dc947eb76c/

Found a couple of correlated messages in the “Event Viewer”.

1) .Net Runtime version 2.0.50727.5420 – Error ‘Invalid syntax on line 166.’ occurred while parsing the ‘Machine’ policy level. The default policy level was used instead.

The fix prescribed in the article is to launch a “command shell” and issue:

C:\Windows\Microsoft.NET\Framework\v2.0.50727\caspol.exe -machine -reset

Did, but no help

Hours later, went back and found another link:

1) SQL Server 2008 Service Pack 2 fails to install
http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/732b0d4d-1422-4631-b738-fcdf22492200/

In an helpful exchange between Deepesh_MSNDN & Costanza, they spoke about target the 64-bit .Net Environment


cd c:\Windows\Microsoft.NET\Framework64\v2.0.50727
caspol.exe -machine -reset

As the machine is 64-bit, targeting 64-bit was most useful.

Couple of places to check per failed install\upgrade:

  • /%program files%/microsoft sql server/100/setup bootstrap/log
  • %userprofile%\appdata\local\temp\SqlSetup.log

References: