Jump to content
Orcy

Migrating Endpoint Security from Windows Server 2008 to 2019

Recommended Posts

I want to move our management console (mbmc version 1.9.03671) from a Windows 2008 VM to a new Windows 2019 VM but I am having problems trying to install it on the new server.

The current sticking point is that it can't find .NET 3.5 Framework - (.Net 4.7 is present on the 2019 VM).

Will this version of mbmc run on Windows 2019? if not, is there are more recent version that will.

Are there work arounds to get this installed.

Thanks.

Share this post


Link to post
Share on other sites

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.

Then follow these instructions for setup:

  1. Choose to create a New Installation.
  2. Choose "New Installation or Add Features" then click Next.
  3. Accept the license, then click Next, then Next again.
  4. Name the instance (I suggest naming it Malwarebytes) then click Next.
  5. Click "Use Same Account for all SQL Server services."
    • On the popup, enter your Windows credentials.
  6. Choose Mixed Mode authentication.  Create a password for the SA account, then click Next.
  7. Click Next two more times and finish the SQL installation.

 

Instructions to attach existing embedded SQL database to new SQL Express external instance:

  1. 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.
  2. Inside “App_Data”, locate the scdb.mdf and scdb.ldf files.
  3. Copy these files to the folder C:\Program Files\Microsoft SQL Server\MSSQL[your SQL version number].[your SQL instance name]\MSSQL\DATA.
  4. On the new SQL Server, open SQL Management Studio and log into your instance.
  5. 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.
  6. Once attached, rename the database from C:\PROGRAM FILES (X86)\MALWAREBYTES MANAGEMENT SERVER\APP_DATA\SCDB.MDF to just scdb, no extension.
  7. 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:

  1. Run the MBMC setup to install Malwarebytes Management Server.
  2. 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.
  3. The installation will connect to the instance and find the existing database as attached.
  4. 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!

Edited by djacobson

Share this post


Link to post
Share on other sites

Thanks for all the details Dyllon, that looks like a lot of work just to move the server! What is the latest version of Windows server where I can just do a reinstall and data restore? I have a Winserver 2016 VM and could probably create a 2012 if needed?


 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

This site uses cookies - We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.