Our company has an XP machine that hosts NStar (Honeywell) software and a database that utilizes MSSQL7, the program is used in conjunction with security keypads at the entrances of the office. Recently the NStar program started crashing while trying to login to the system to add/remove access for employees. When trying to start two services which connect to the database, the connection to the database fails and errors are generated in the eventlog:
Errors logged in the Event Log:
Under Application:
Source: Application Error
Type: Error
Category: (100)
Event ID: 1000
Description: Faulting application NCICore.exe, version 0.0.0.0, faulting module msvcrt.dll, version 7.0.2600.5512, fault address 0x00037124.
Source: Application Error
Type: Error
Category: (100)
Event ID: 1000
Description: Faulting application NCIArchive.exe, version 0.0.0.0, faulting module msvcrt.dll, version 7.0.2600.5512, fault address 0x00037168
Source: NStar Communications Server
Type: Error
Category: (1)
Event ID: 0
Description: The description for Event ID (0) in Source (NStar Communications Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use /AUXSOURCE=flag to retrieve this description; see Help and Support for details. The following information is part of the event:, Connect to DB Server Failed! Code: 203.
Under system:
Source: Service Control Manager
Type: Error
Category: None
Event ID: 7034
Description: the NStar Database Server service terminated unexpectedly. It has done this 4 times.
Under Application:
Source: Application Error
Type: Error
Category: (100)
Event ID: 1000
Description: Faulting application NCICore.exe, version 0.0.0.0, faulting module msvcrt.dll, version 7.0.2600.5512, fault address 0x00037124.
Source: Application Error
Type: Error
Category: (100)
Event ID: 1000
Description: Faulting application NCIArchive.exe, version 0.0.0.0, faulting module msvcrt.dll, version 7.0.2600.5512, fault address 0x00037168
Source: NStar Communications Server
Type: Error
Category: (1)
Event ID: 0
Description: The description for Event ID (0) in Source (NStar Communications Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use /AUXSOURCE=flag to retrieve this description; see Help and Support for details. The following information is part of the event:, Connect to DB Server Failed! Code: 203.
Under system:
Source: Service Control Manager
Type: Error
Category: None
Event ID: 7034
Description: the NStar Database Server service terminated unexpectedly. It has done this 4 times.
Solution:-
one of the updates has altered and added additional time zone entries in the registry,
hkey_local_machine\software\microsoft\windowsnt\currentversion\timezones
I had to remove, bangladsh standard time, fiji standard time, kamchatka standard time, morocco standard time, pacfic sa standard time, paraguay standard time, syria standard time,
Once I did this, i restarted the service and it works.
if the number of time zones exceeds 99, then the database server will not connect due to the 2 digit limitation.
