🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: bit.databases.mssql-l
Article #2090

Re: SQL Monitor Problem

#2090
From: robert.w.christensen
Date: Fri, 07 Apr 1995 00:00
39 lines
2017 bytes
> 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

To resolve this problem, you have to change one of the SQL Monitor services
parameters in the Windows NT Registry.  Here's how step by step:

1. From Program Manager, select File/Run and enter

regedt32

This will start the regedit32 application

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

3. Double-click on the nodes 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 acount's password.

5. Close the Registry Editor.

You SQLMonitor service should now start correctly.
Technical Details
Message-ID: <9504072006.AA9781@CServe-Hub2.inhouse.compuserve.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,c63c97007223773f
X-Google-Attributes: gidf6611,public
From: "robert.w.christensen" <robert.w.christensen@AA.COMPUSERVE.COM>
Subject: Re: SQL Monitor Problem
Date: 1995/04/07
Message-ID: <9504072006.AA9781@CServe-Hub2.inhouse.compuserve.com>
X-Deja-AN: 100102393
sender: Microsoft SQL Server Discussion List
comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
content-type: Text/Plain
mime-version: 1.0
newsgroups: bit.databases.mssql-l