Problem Solved
Following research by Mathias
From: Mathias Burbach
Sent: Sunday, 25 July 2021 6:35 PM
To: Eric March
Subject: Re: MS SQL Server 2019 - connection issues
Hello Eric,
I had another look at the MS SQL Server documentation and found the following sentence here:
To enhance security, the Database Engine of SQL Server Developer, Express, and Evaluation editions cannot be accessed from another computer when initially installed. This lesson shows you how to enable the protocols, configure the ports, and configure the Windows Firewall for connecting from other computers.
That link above should enable us to step through the instructions step by step and setup your Windows Server 2019 together with MS SQL Server Express 2017 so you can in fact connect from another machine in the network. One thing we have not done today is to assign a fixed port to your MS SQL Server Express instance and then to adjust the Firewall settings accordingly.
Please try the “Lesson 2: Connecting from Another Computer” or do it together with your nice.
Salut,
Mathias