Skip to main content

Database Configuration

To configure screen, follow these steps:

1.  On the Database Configuration screen, enter Database Server, Database Driver, Username, Password, and click Install SQL Express.

note

i. Default server path is localhost\SQLEXPRESS.*

ii. In case of SQL Server, provide SQL server database instance name in server path and username/password.

iii. It is mandatory to install SQL v2016 for the on-premise build version 6.58 onwards for a new deployment/ SureMDM package upgrade.

iv. It is mandatory to install MongoDB v4.2.x for the On-premise build v6.58 onwards for a new deployment/ SureMDM package upgrade.

v. It is mandatory to use Database Driver: ODBC Driver 17 for SQL Server for the On-premise build v6.59 onwards.

 Image

2.  Enter all the required details and click Test Connection.

A prompt appears on successful test connection.

     Image

3.  Click OK and Save at top right corner of the screen.

4.  DB string in MongoDB Connection String will be auto-populated.

     To know how to setup and configure MongoDB, see MongoDB Setup.

     To know how to setup and configure MongoDB Atlas, see MongoDB Atlas Setup.

note

Default DB String will be mongodb://127.0.0.1:27017. If the MongoDB is installed in a different instance, replace the localhost IP with the destination server IP.