Is SQL Server 2017 supported?

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
vladosha
New user
New user
Posts: 1
Joined: 2019-02-16 13:48

Is SQL Server 2017 supported?

Post by vladosha » 2019-02-16 19:40

I have MS SQL Server 2017.
Set to use MS SQL Server, but during creation of database got the error "Server not found or access denied"

I tried several times, also with another user and integrated security too.
Firewall has no blocked items in log.
SQL Server works fine, I also checked it out.

Does hMailServer work with MS SQL Server 2017 at all?

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

Re: Is SQL Server 2017 supported?

Post by mattg » 2019-02-17 00:24

Doesn't SQL Server 2017 need an encrypted connection? Have you checked and rechecked your credentials. HMailserver creates the database as part of the install, do your permissions allow that?
Does SQL Server log anything?

And yes, there are some users who are using SQL Server 2017
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

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

Re: Is SQL Server 2017 supported?

Post by Dravion » 2019-02-17 04:56

vladosha wrote:
2019-02-16 19:40
Does hMailServer work with MS SQL Server 2017 at all?
It does.
This should help you make it work
viewtopic.php?f=21&t=32852

PS:
This Tutorial is for a combination of Win10 64-Bit, MS-SQL-Server 2017 64-Bit (Express/Standard and Enterprise-Edition) configured in mixed mode with a seperate Database User for hMailServer instead of Windows Authentication (LocalDB is not coverred in this Tutorial).

Warning:
The referenced hMailServer Version is hMailServer 5.6.7 LTS 64-Bit, built for Windows 64-Bit only (AMD64) which requires a Preinstallation of MS-OLEDB Provider Version 18 64-Bit which will enforce
TLSv1.2 encryption between MS-SQL-Server 2017 and this special hMailServer version.

Hint:
This is not a official build of hMailServer, its a custom build of the official hMailServer code intended for Longterm 64-Bit Support for hMailServer but you can also use your hMailServer 5.6.7 32-Bit (official) build to make it work as well.

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

Re: Is SQL Server 2017 supported?

Post by Dravion » 2019-02-17 06:37

vladosha wrote:
2019-02-16 19:40
I have MS SQL Server 2017.
Set to use MS SQL Server, but during creation of database got the error "Server not found or access denied"
Keep in Mind:

SQL-Server doesnt activate TCP/IP (regardles if IPv4 or IPv6) by Default.
If you want to connect to a Remote SQL-Server, you have to enable TCP-IP Connections in SQL-Server Config Wizzard.
Make sure you dont use Dynamic ports, which makes SQL-Server access ports unpredictable. Type in Port 1433 for all Connections
as static.

If your SQL-Server is installed on the same Computer as hMailserver you dont need to enable TCP/IP.
Just use "LOCALHOST\SQLEXPRESS" (for SQL-Server Express or your manually configured SQL-Server Instance)
in the Host/Server Connection field to connect via Shared Memory Connections.

Post Reply