Jump to content

Migrate Malwarebytes from one SQL Server express to another


Recommended Posts

Hi!

We have two instances of SQL Server Express on one host. One instance SQL Server Express 2008 and another SQL Server Express 2012. MB Server originally installed on 2008.

We did steps described in this video https://support.malwarebytes.com/docs/DOC-1047

Now in Malwarebytes we see new 2012 SQL Server Express in Database settings tab. All ok and looks work, but when we stop 2008 instance, MB Console did not connect. In future we need decomissioning 2008 SQL Express.

Any idea? 

Edited by voyatrg
Link to post
Share on other sites

Here’s the process of going from embedded Express to external Express I wrote, it has a bit more detail than that KB:

  1. Go to C:\Program Files (x86)\Malwarebytes Management Server\App_Data to locate the scdb.mdf and scdb.ldf files
  2. Copy these files to the folder C:\Program Files\Microsoft SQL Server\mssql[your version number].MSSQLSERVER\mssql\data\
  3. On the server's new SQL instance, log in to SQL Management Studio, use the version that matches or Express install
  4. Attach the scdb.MDF file
  5. Once attached, rename the database from C:\Program Files (x86)\Malwarebytes Management Server\App_Data\scbd.mdf to just scdb, no extension
  6. Log in to the Management Console
  7. Click the Admin Pane on the left
  8. On the Overview tab, under SQL Database Setting, click Change
  9. Enter the address, instance name, and user information for the SQL server. If the instance is located on the server locally, use .\[instanceName]. The SQL must be in mixed mode, attaching with Windows credentials is not supported, the account must be SA or db_owner. Other configuration requirements, you’ll need to enable Named Pipes and tcp/IP on your SQL Server.
  10. The Management Console should disconnect, verify your IP and ports are correct in the Server Configuration tool. It is located in Start > All Programs > Malwarebytes Management Server > Server Configuration. You should then be able to log on. Once verified, you can stop the service for your 2008 Express.

 

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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
Back to top
×
×
  • 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.