sql errors for hmailserver after each windows update and restart

[charleso]

Please each time i do a windows update on my 2016 windows server, every 2-3 months , i run into one sql server connection error on Hmailserver on another.

This is the latest error:

Code: Select all

ADO [DBNETLIB][ConnectionRead (recv()).]General network error.

Please is there anything i can do to fix this. my mail server has been down for hours.

Thanks.

[mattg]

Is your SQL server on another machine?
Which database do you use?
Please show the contents of your hmailserver.ini file with passwords removed

[charleso]

IT's all on the same machine.

SQL Server 2017 standard

Code: Select all

[Directories]
ProgramFolder=C:\Program Files (x86)\hMailServer
DatabaseFolder=C:\Program Files (x86)\hMailServer\Database
DataFolder=C:\Program Files (x86)\hMailServer\Data
LogFolder=C:\Program Files (x86)\hMailServer\Logs
TempFolder=C:\Program Files (x86)\hMailServer\Temp
EventFolder=C:\Program Files (x86)\hMailServer\Events
[GUILanguages]
ValidLanguages=english,swedish
[Security]
AdministratorPassword=XXX
[Database]
Type=MSSQL
Username=sa
Password=XXX
PasswordEncryption=1
Port=0
Server=.
Database=mailserver
Internal=0
[Settings]
DisableAUTHList=25
; Setting DisableAUTHList allows you to specify a comma-separated list of SMTP ports which authentication should not be enabled for.
; This is useful when working with legacy systems with malfunctioning SMTP support.

This is the config i have been using for several months. It's just after today's windows update which included Security Update for SQL Server 2017 (KB4494351), that this error started on restarting the machine

[charleso]

SOLVED:

simply upgraded to a newer version of HmailServer

[charleso]

wow, now i restart and get this:

Please any help?

[jimimaseye]

Perhaps you should review the detail behind the windows update KB4494351 (that caused you the problem). Maybe there are new features/securities in place that you need to work through. Also, check the database is available (port, name, etc). After all, Hmailserver is merely trying to connect to a database that you have told it to and something is stopping it from doing so. (Is it there? Available? TLS required?)

[charleso]

Perhaps you should review the detail behind the windows update KB4494351 (that caused you the problem). Maybe there are new features/securities in place that you need to work through. Also, check the database is available (port, name, etc). After all, Hmailserver is merely trying to connect to a database that you have told it to and something is stopping it from doing so. (Is it there? Available? TLS required?)

The SQL server works fine, i can even access it remotely. Other applications accessing the same sql server have no issues, just hMailServer fails ... even after successfully upgrading to the laters version this morning

[jimimaseye]

The SQL server works fine, i can even access it remotely. Other applications accessing the same sql server have no issues, just hMailServer fails ... even after successfully upgrading to the laters version this morning

Upgrading HMS will not make a difference. You have a configuration issue that has been introduced by that last Windows Update. HMS will only try to connect according to how it, and the machine it runs on, has been configured.

[charleso]

I installed the updated hmailserver this morning, and it all worked fine.

I restarted the server , and now i have this issue.

I have not changed any configs.

[Dravion]

The Database is not ready or reachable as hMailServer
at this point time. Durnibg Setup, make sure you selected the MSSQL Service as Dependency.

[jimimaseye]

I have not changed any configs.

....and you didnt change HMS either.

But you HAVE changed the machine setup (by doing a reboot). Services stop and should restart (but maybe dont). Dependancies change. As Dravion says, check the service dependancies.

[charleso]

steps:

1) restarted the server
2) ensure MSSQLSERVER service is running
3) ensure i can connect / access the sql server remotely from my laptop
4) then i remote into the server and try to start hMailServer Asministrator

I then get the error:

[jimimaseye]

Durnibg Setup, make sure you selected the MSSQL Service as Dependency.

Run "DBSetup".......

[charleso]

Durnibg Setup, make sure you selected the MSSQL Service as Dependency.

Run "DBSetup".......

WOW it works now. God Bless!

... but let me restart the server and see if the problem comes again

[charleso]

Restarted successfully!. Thanks again