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

The first time you open ATRS, you will need to configure the ATRS database. This article describes how to configure ATRS 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 ATRS.
  • You should now see a Database Configuration Wizard pop up. Click Next.
  • Select Use my existing database server and click on Next.
  • Here, you can 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 ATRS can successfully connect to your SQL Server, click Next. 
The SQL Server credentials must have permissions to read/write/create.
  • A pop-up will appear saying the test succeeded. Click OK.
  • The database is now being created within your own database server.
  • Click Finish when the process is complete.
  • ATRS is now configured to store the scheduling information in a database on your server.