NT problem

Wojtek Rappak  writes:

>Following a re-install of NT I wrecked something that used to 
>work. I used to have Ingres run as an automatic startup service
>and now I can only have it run as a manual service. I don't know what 
>happened nor how it can be fixed.

>Symptoms as follows.

>I have Ingres set up as a manual service and it starts up 
>correctly when selected from Services with 'ingres' as the current
>user.  I want it to start automatically at boot-time.  I set it up 
>for automatic startup under user ingres with ingres's current password 
>set to 'never expire'.  It won't start on boot.  I tried system password,
>tried running crserver without any result.  No clues or diagnostic 
>messages, nothing in the event log. The June '94 release notes don't 
>help. 

>I have a faint recollection of some devious secret setting for automatic
>service.  Perhaps someone can recall it?
>-- 
>------------------------------------------------------------
>Wojtek Rappak                   wojtek@cssys.demon.co.uk

Got this working after a great deal of night time programming...  There 
was some thing about this in the release notes, which I do not have with 
me.  I ended up in some NT facility for maintaining services, where I 
manually changed an entry.  Call me, may be I can talk you through it.
-- 
Graham Bolton, Principal Consultant
Elegant Relational Development (ERD) bv
Hoogstraat 125a, NL-3111 HD  SCHIEDAM, The Netherlands
Tel: +31.10.2732233, Fax: +31.10.2731114



In article <950627$185253$5685afmmmr@ozemail.com.au>
           afmmmr@ozemail.com.au "Micheal Watson" writes:

> gbolton@inter.NL.net (Graham James Bolton) wrote:
> 
>  >Got this working after a great deal of night time programming...  There 
>  >was some thing about this in the release notes, which I do not have with 
>  >me.  I ended up in some NT facility for maintaining services, where I 
>  >manually changed an entry.  Call me, may be I can talk you through it.
> 
> I couldn't find anything in the release notes(no surprise), what page was it?
> 
> Which service did you change and what to??
> 
> Thanks.
> 

I think that Graham is referring to the release notes for 6.4/05(int.wnt/01)
dated June 1994.  Page 9 has a section on 'Running INGRES as an NT service'.
Everything there is self-explanatory:  ingres is set up as a manual startup
service during install (via the crserver utility), you make it autostart
through the services startup panel, specifying logon through the ingres
user (not the system user) and password.  By the way, the ingres user 
password has to be set to 'never expires' through the user manager.  

As far as I can gather, there are two places in the NT registry which are
affected by ingres.  HKEY_CLASSES_ROOT\INGRES_Database\shell has the 
setting for II_SYSTEM.  HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\
INGRES_Database has the service entries.  The 'Start' entry will have a value
of 0x2 for autostart and 0x3 for manual.  A useful tip may save you hours
here:  when the ingres autostart fails it appears to lock certain registry 
hives and you get a 'Service Database Locked' error message.  The way around
this is to change the 'Start' entry to 0x3 via the registry editor and reboot.

I know all this and I don't think there is much else to know here.  And yet
I have not been able to get the autostart service running on my P100 for 
over a month.  There is only one clue: it used to work before I installed
RAS networking.   

------------------------------------------------------------
Wojtek Rappak                   wojtek@cssys.demon.co.uk
Ingres Q & A
To William's Home Page
Email William