MBMC is unable to install normally on Server 2019 because of the built-in embedded SQL Express 2008 R2, this is not supported by Server 2019. MBMC can still install if you choose to use an external SQL that you connect it to instead.
Other items to note that will trip up Server 2019;
MBMC installer needs TLS 1.0 to be enabled during the install portion, TLS 1.0 can be disabled once again after the installation is complete.
Second is modern Microsoft Server OS comes with IIS 8 Express, or IIS 8.5 Express, installed and enabled by default. This is a conflict for our installer process. IIS8+ needs to be removed or an alternate server without this role needs to be chosen. The MBMC console requires the use of IIS 7.5 Express for its reporting function. If the server isn't actively using the IIS 8+ Express, the admin can disable the built-in 8+ Express role in Server Roles and Features prior to MBMC install.
Items needed are SQL Management Studio, a newer Server 2019 supported SQL Express, and the exact same MBMC installer as your existing MBMC Console. Do not attempt to upgrade MBMC versions during a migration!
Instructions for creating SQL Express external instance setup:
Download a new SQL Express installer.
SQL Server 2014 Express:https://www.microsoft.com/en-us/download/confirmation.aspx?id=42299
SQL Server 2016 Express:https://www.microsoft.com/en-us/download/confirmation.aspx?id=52679
Then follow these instructions for setup:
Choose to create a New Installation.
Choose "New Installation or Add Features" then click Next.
Accept the license, then click Next, then Next again.
Name the instance (I suggest naming it Malwarebytes) then click Next.
Click "Use Same Account for all SQL Server services."
On the popup, enter your Windows credentials.
Choose Mixed Mode authentication. Create a password for the SA account, then click Next.
Click Next two more times and finish the SQL installation.
Instructions to attach existing embedded SQL database to new SQL Express external instance:
On your old MBMC server, go to C:\Program Files (x86)\Malwarebytes Management Server\App_Data, the directory may also be named "C:\Program Files (x86)\Enterprise Edition\App_Data" if you've had MBMC early versions.
Inside “App_Data”, locate the scdb.mdf and scdb.ldf files.
Copy these files to the folder C:\Program Files\Microsoft SQL Server\MSSQL[your SQL version number].[your SQL instance name]\MSSQL\DATA.
On the new SQL Server, open SQL Management Studio and log into your instance.
In the menu on the right, right-click on the "Databases" folder under your SQL instance and select "Attach", navigate to the MSSQL folder where you previously copied the files and select the scdb.mdf database file.
Once attached, rename the database from C:\PROGRAM FILES (X86)\MALWAREBYTES MANAGEMENT SERVER\APP_DATA\SCDB.MDF to just scdb, no extension.
Use SQL Server Configuration Manager to enable Named Pipes and TCP/IP on your SQL Server setup - see this link if help is needed - https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-network-protocol?view=sql-server-ver15#SSMSProcedure
Instructions to connect MBMC install on new server to the new external SQL Express instance:
Run the MBMC setup to install Malwarebytes Management Server.
On the SQL step choose 'Use External Database."
Enter the Database Address, if named Malwarebytes from the first instruction set on step 4, it will be ".\Malwarebytes", without the quotes.
Enter the username as SA, and then the password you created for it.
The installation will connect to the instance and find the existing database as attached.
Installation will complete and you will be prompted to log on to MBMC, all previous existing accounts on the old server before the migration will be available to use. All previous settings / policies / agents will be right where you left them.
Hope this helps!