Error in Log file

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
PeterChan
Normal user
Normal user
Posts: 87
Joined: 2018-06-23 15:45

Error in Log file

Post by PeterChan » 2020-01-24 09:43

Hi,
What to check, due to error below, in Log file?
"ERROR" 1472 "2020-01-24 11:51:45.944" "Severity: 1 (Critical), Code: HM5028, Source: ADOConnection::Connect, Description: Error when connecting to database. Microsoft OLE DB Provider for SQL Server Cannot open database "hMailserver" requested by the login. The login failed. Check your database settings in hMailServer.ini."
"ERROR" 1472 "2020-01-24 11:51:50.977" "Severity: 1 (Critical), Code: HM5028, Source: ADOConnection::Connect, Description: Error when connecting to database. Microsoft OLE DB Provider for SQL Server Cannot open database "hMailserver" requested by the login. The login failed. Check your database settings in hMailServer.ini."

User avatar
Dravion
Senior user
Senior user
Posts: 1688
Joined: 2015-09-26 11:50
Location: Germany
Contact:

Re: Error in Log file

Post by Dravion » 2020-01-24 11:23

Your Database Username or Password or both is wrong.

PeterChan
Normal user
Normal user
Posts: 87
Joined: 2018-06-23 15:45

Re: Error in Log file

Post by PeterChan » 2020-01-24 13:42

Thanks. How to re-configure user, due to password issue?

User avatar
Dravion
Senior user
Senior user
Posts: 1688
Joined: 2015-09-26 11:50
Location: Germany
Contact:

Re: Error in Log file

Post by Dravion » 2020-01-24 17:23

PeterChan wrote:
2020-01-24 13:42
Thanks. How to re-configure user, due to password issue?
This goes for any Database hMailServer is supporting (except for MS-SQL-CE Internal Database).

First of all, you need to know the SQL-Database server Administrator's Username and its Password.
Only a Database Server Administrator Account can Setup a new DB Username+Password. hMailServer can and will not create a SQL-Database User for you,
so you need to type in your Database Administrators Username+Password (bad practice) or you create a Database User for hMailServer to connect with before you
are trying to install hMailServer.

PeterChan
Normal user
Normal user
Posts: 87
Joined: 2018-06-23 15:45

Re: Error in Log file

Post by PeterChan » 2020-01-27 17:30

Thanks.

I did finish hMailserver setup before this. If I want to use other user account, does it mean I can re-run hMailserver to re-configure other user account?

User avatar
mattg
Moderator
Moderator
Posts: 21257
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Error in Log file

Post by mattg » 2020-01-28 03:10

Assuming that you have no data that you wish to keep

Uninstall hMailserver
Delete hmailserver folder and all subfolders, especially the hmailserver.ini

Reinstall hmailserver
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

Post Reply