Jump to content

Move management db from External to Embedded


Recommended Posts

We have a small management database (40 users) which was installed on SQL2012 server.  As I plan to dedicate the SQL server for a large finance system, I want to migrate our MalwareBytes db to use the basic "Embedded" databare mode.   How can I do this without losing our data?   

Link to post
Share on other sites

  • Staff

Hey Tamborine,

Unfortunately you won't be able to go from the full version to the embedded we install if you already had that setup. However, you can create and install a SQL express instance specifically for our database and connect it that way. To do this:

First, download a new SQL Express Server 2008 R2 installation here:

 

https://www.microsoft.com/en-us/download/confirmation.aspx?id=30438

 

Then, please 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."

a. On the popup, enter your Windows credentials.

7) Choose Mixed Mode authentication.  Create a password for the SA account, then click Next.

8) Click Next two more times and finish the SQL installation.

Once you do that, you need to attach the database files to the new instance you created. Once you do that:

 

1. On your existing Management Server, log in to the Management Console
2. Click the Admin Pane on the left
3. On the Overview tab, under SQL Database Setting, click Change
4. Enter the address, instance name, and user information (sql account required) for the SQL server
5. The Management Console should disconnect, and then you should be able to log in again
As far as configuration requirements go, you'll need to enable Named Pipes and TCP/IP on your SQL Server if it is a database on another server. 

Once you do that, you should be all set and connected.


 

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.