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.
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.
2. Enter all the required details and click Test Connection.
A prompt appears on successful test connection.
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.
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.