SQLMonitor Service Terminates If SA Password Changes

ID: Q147558

The information in this article applies to:

SUMMARY

The SQLMonitor Service on Windows NT uses the SQL Server System Administrator (SA) account to access SQL Server for Windows NT. If the SA account's password is changed from the default, which is none or NULL, any attempt to start the SQLMonitor service results in the following error:

Error 2186 The service is not responding to the control function.
Could not start the SQLMonitor service on \\Server.


MORE INFORMATION

To resolve this problem, change one of the SQL Monitor services parameters in the Windows NT Registry. Sites with SQL Server version 4.21 or later can change the parameter by starting SQL Monitor from the command line with the /NEWPASSWORD switch:

netsql start sqlmonitor /NEWPASSWORD=[newpass]

NOTE: The SQL Monitor service only needs to be started this way once; it will remember the new parameter on future starts of the service.

Sites with versions of SQL Server for Windows NT earlier than 4.21 must update the Windows NT registry using the following procedure:
  1. From the Program Manager of the Windows NT server, select the File menu and choose Run. Enter the following:

    regedt32


    2. NOTE: This will start the Registry Editor (REGEDIT32.EXE application).

  2. Set focus on the Registry Editor applications window titled "HKEY_LOCAL_MACHINE on Local Machine."


  3. Double-click on the folders in the left window, expanding the tree in the following order:

    \SOFTWARE\Microsoft\SQLServer\SQLMonitor\Parameters

    You should now see a line that reads: Password:REG_SZ: in the right window of the "HKEY_LOCAL_MACHINE on Local Machine" window.


  4. Double-click on the Password line in the right window. You should now see a dialog box prompting you for a string. Enter the password for the SA account, and press the OK button.

    The Password:REG_SZ: entry should contain your SA account's password.


  5. Close the Registry Editor.


Your SQLMonitor service should now start correctly.

Additional query words: Windows NT monitor backups admin 


Keywords          : kbtool SSrvAdmin SSrvMon ntnetserv NTSrv 
Version           : 3.1 3.5 3.51 4.2 4.0
Platform          : winnt 
Issue type        :

Last Reviewed: February 10, 1999