Change to other account

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

Change to other account

Post by PeterChan » 2020-01-29 04:11

Hi,
How to configure one other account vs SQL server?

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

Re: Change to other account

Post by mattg » 2020-01-29 05:12

You want to change your SQL server connection account?

Create a new user in SQL using SQL Server Management Studio or similar, AND then change the hmailserver.ini to reflect the change
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

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

Re: Change to other account

Post by PeterChan » 2020-01-29 05:20

Thanks. Previous password was encrypted below
Username=sa
Password=****************removed********
How to put other password well?

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

Re: Change to other account

Post by mattg » 2020-01-29 05:45

It is Blowfish encrypted


./bin/DBSetupQuick.exe is probably easiest way to enter new username and password
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

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

Re: Change to other account

Post by PeterChan » 2020-01-29 10:58

Sorry, nothing comes out, in the following
21a.png
21a.png (6.14 KiB) Viewed 5307 times

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

Re: Change to other account

Post by Dravion » 2020-01-29 14:14

DBQuick.exe does this:

Code: Select all

if (_application.Database.DatabaseType == hMailServer.eDBtype.hDBTypeMSSQLCE ||
             _application.Database.DatabaseType == hMailServer.eDBtype.hDBTypeUnknown)
         {
            InitializeInternalDatabase();
}
It basically creates a Internal MS-SQL-CE Database, but it doesn't create a MS-SQL Server (not CE), a MySQL or PostgreSQL Database, but it launches DBUpdater.exe if a Database
was already created and needs a updated Database SQL-Structure or Data. DBUpdater.exe quits if nothing is to do.

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

Re: Change to other account

Post by PeterChan » 2020-01-30 05:50

Hi,
What does nothing happen, when I call "DBSetupQuick.exe"?

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

Re: Change to other account

Post by PeterChan » 2020-01-31 06:39

Hi,
Any help?

Post Reply