How to use MS-SQL database in Mobile Device Manager Plus MSP?

Mobile Device Manager Plus extends support for using MS-SQL database for storing the configuration and data. MDM supports MS-SQL database from the 2005 edition.

The steps for configuring MDM to utilize MS-SQL database is explained below:

NOTE: Do not start the MDM server before configuring the database.

Changing database to MS SQL

In the machine where MS-SQL Server is installed,

1. Click Start --> Run and type services.msc.
2. Ensure SQL Browser service has been started. If not, start the service.
3. Open the SQL Server Configuration Manager from the Start menu.
4. Expand SQL Server Configuration Manager (Local) and navigate to SQL Server Network Configuration.
5. Select the instance on which you want to run the database and check if TCP/IP ports are enabled. If not, right-click on TCP/IP and enable it.
6. Select SQL Server Services from the left pane, right-click the instance and choose Restart.

   

7. In case of a fresh MDM installation, open Microsoft SQL Server Management Studio and go to Mobile Device Manager Plus database.
8. Right click on memdm folder and select Properties. Under the section Maintenance and select the option SQL_Latin1_General_CP1_CI_AS for Collation.

Migrating data to MS SQL database

In the machine where MDM Server is installed,

1. Navigate to the folder where Mobile Device Manager Plus is installed and click on the bin folder. Open changeDBServer.bat as Administrator.
2. Select Database Type as SQL Server.
3. Specify the Host Name where SQL Server is installed.
4. From the list of available instances, select the instance on which you wish to run the database.
5. You can choose to authenticate the database connection either using Windows Authentication or SQL Server Authentication. Choose the required authentication and provide the credentials.

   

   

6. Select the check box to enable NTLM authentication.
7. If it is an existing installation of MDM, ensure the check box Migrate data from existing database is selected and If it is a fresh installation of MDM, ensure the check box Migrate data from existing database is not selected.  
8. Click Test to check whether a connection could be established with the given credential.
9. Click Save to save and complete the SQL Server Configuration. It may take a few minutes to configure the settings on the SQL Server, in case of an existing installation of MDM depending on the database size.
10. Once the database is migration has been fully completed, start Mobile Device Manager Plus. 

NOTE: During migration, if there is an Authentication Error, verify the specified credentials.(Do not take a back up of the database again.)