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.
-
PeterChan
- Normal user

- Posts: 87
- Joined: 2018-06-23 15:45
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."
-
Dravion
- Senior user

- Posts: 1674
- Joined: 2015-09-26 11:50
- Location: Germany
-
Contact:
Post
by Dravion » 2020-01-24 11:23
Your Database Username or Password or both is wrong.
-
PeterChan
- Normal user

- Posts: 87
- Joined: 2018-06-23 15:45
Post
by PeterChan » 2020-01-24 13:42
Thanks. How to re-configure user, due to password issue?
-
Dravion
- Senior user

- Posts: 1674
- Joined: 2015-09-26 11:50
- Location: Germany
-
Contact:
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

- Posts: 87
- Joined: 2018-06-23 15:45
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?
-
mattg
- Moderator

- Posts: 21320
- Joined: 2007-06-14 05:12
- Location: 'The Outback' Australia
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