Can someone send me a screen shot of how Password Reset Listener should look? I am trying to change the password on 3 MS SQL service accounts, SQLSERVERAGENT, ReportServer, and MSSQLSERVER however MSSQLSERVER never stops becuase SQLSERERAGENT is dependent on it so I want to run a script after the password is changed to start and stop it. Here is the script,
strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
Set colServiceList = objWMIService.ExecQuery("Associators of " _
& "{Win32_Service.Name='mssqlserver'} Where " _
& "AssocClass=Win32_DependentService " & "Role=Antecedent" )
For Each objService in colServiceList
objService.StopService()
Next
Wscript.Sleep 10000
Set colServiceList = objWMIService.ExecQuery _
("Select * from Win32_Service where Name='mssqlserver'")
For Each objService in colServiceList
errReturn = objService.StopService()
Next
Password manager says it invokes the script but it never runs on the server. Any help would be greatly appreciated.