How do I install and configure MARS to use my existing database server?

The first time you open MARS, you will need to configure the MARS database. This article describes how to configure MARS to use your existing database instead of installing its own.

Use My Existing Database Server

You will need to have your SQL Server name and a SQL Server account (username and password) which have read/write/create permissions.
  • Open MARS.
open pbrs-3
  • You should now see a Database Configuration Wizard pop up. Click Next.
Image 10-4
  • Select Use my existing database server and click on the Next.
Image 16-4

Enter the details of your SQL Server, check the option Create Database (existing database will be dropped) and enter the credentials of your SQL Server account. Click Test. Once MARS can successfully connect to your SQL Server, click Next. 

Image 18-5
The SQL Server credentials must have permissions to read/write/create.
  • Click OK.
7-26-2018 2-22-41 PM-3
  • The database is now being created within your own database server.
Image 12-4
  • Click Finish to complete the database configuration.
Image 14-4
  • MARS is now configured to store the scheduling information in a database on your server.