Once you correct the wp_login account access to the hMailserver database. If you can, potentially you gave it read rights but no write rights. see if in this session you can expand the hMailserver database. Use SSMS, and establish a new connection to this server, using sql login with the wp_login/password. You initially used the sa account, you may have created the ws_login, but you might not have granted it requisite rights. They usually go through the setup of the DB in SQL and then creation of the user acccount that will be used by hmailserver to access this DB. Under user mapping make sure this account has DBO rights to the Hmailserver DB or as specified in the HMailserver setup. Looking at the security/application event log on the sql server to see whether the login attempts are/were being denied the log says it could not access the DB with the information it has, attributing the failure to username/password related issues I would uncheck the enforce password policy, you can make the password as complex as you need it to be without that check mark. How to resolve this issue with hMailserver? While I have no problem at all to login SQL server by the same account. While here is hMailserver.ini file ProgramFolder=C:\Program Files (x86)\hMailServer DatabaseFolder= 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 ValidLanguages=english,swedish AdministratorPassword=12b348791e3e0c7dc5ea083819c345a7 Type=MSSQL Username=ws_login Password=240e36c5afc5fa6a PasswordEncryption=1 Port=0 Server=WIN-BPJ35QGB8MN\SS2012EXPR Database=hMailserver Internal=0 Error message: ADO: Cannot open database "hMailserver" requested by the login. Check your database settings in hMailServer.ini." "ERROR"đ532 " 09:33:33.609" "Severity: 1 (Critical), Code: HM4354, Source: Application::OpenDatabase, Description: hMailServer failed to connect to the database server. Microsoft OLE DB Provider for SQL Server Cannot open database "hMailserver" requested by the login. Check your database settings in hMailServer.ini." "ERROR"đ532 " 09:33:28.602" "Severity: 1 (Critical), Code: HM5028, Source: ADOConnection::Connect, Description: Error when connecting to database. Check your database settings in hMailServer.ini." "ERROR"đ532 " 09:33:23.578" "Severity: 1 (Critical), Code: HM5028, Source: ADOConnection::Connect, Description: Error when connecting to database. Check your database settings in hMailServer.ini." "ERROR"đ532 " 09:33:18.555" "Severity: 1 (Critical), Code: HM5028, Source: ADOConnection::Connect, Description: Error when connecting to database. Check your database settings in hMailServer.ini." "ERROR"đ532 " 09:33:12.081" "Severity: 1 (Critical), Code: HM5028, Source: ADOConnection::Connect, Description: Error when connecting to database. Microsoft OLE DB Provider for SQL Server SQL Server does not exist or access denied. Check your database settings in hMailServer.ini." "ERROR"đ532 " 09:33:05.779" "Severity: 1 (Critical), Code: HM5028, Source: ADOConnection::Connect, Description: Error when connecting to database. Now I got these (in hMailserver) "ERROR"đ532 " 09:32:43.986" "Severity: 1 (Critical), Code: HM5028, Source: ADOConnection::Connect, Description: Error when connecting to database. On the same server, I was ever able to send out message fine, through hMailserver.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |