🚀 go-pugleaf

On Fri, 7 Apr 1995, Brenda Landry wrote:

> I just installed SQL Server and after I changed the sa password from blank to
> an actual password, the SQLMonitor will no longer start from Service Manager.
> SqlServer starts fine.  If I go to the command line and type "netsql start
> sqlmonitor /newpassword=xxxxxxx" the SQLMonitor will start, but I still can't
> start it as a service.  The only error message I get is "SQLMonitor service
> terminated due to service specific error #1" whatever that is.  Any help would
> be appreciated.
>
> TIA ... Brenda
>

I remember the first time this happenned to me!  Kind of sets you back,
doesn't it?  This is not hard to fix, though.

You have to use REGEDT32 to put the password in the NT registry.  This
is best done from the console/keyboard of the server itself.  Open a DOS
window and start regedt32.  To change the password, select the box that
says "HKEY_LOCAL_MACHINE" and then follow the tree down, as follows:

Software
  Microsoft
    Sqlserver
      Sqlmonitor
        Parameters

The right side of the box should show a bunch of parameters, including
"Password".  Double-click and edit the password.  If for any reason, the
password parameter doesn't exist, you probably have an ancient version
of the software, but it can be added with the editor.  I should'nt worry
about it, though, you probably already have the entry.

All you have to do then is manually start the SQLMonitor with the SQL
Service Manager tool.  It'll be fine until you change the pw again!

Let me know how it works out.

 -- Paul.  <flint@io.org>