How do I install and configure SQL-RD to use my existing database server?

The first time you open SQL-RD, you will need to configure the SQL-RD database. This article describes how to configure SQL-RD 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 SQL-RD
SSRS. SQL-RD in your server.
  • You should now see a Database Configuration Wizard pop up. Click Next.
SQL-RD Database Configuration Wizard.
  • Select Use my existing database server and click on the Next.
SQL-RD Database Configuration Wizard.

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 SQL-RD can successfully connect to your SQL Server, click Next. 

SQL-RD Database Configuration Wizard.
The SQL Server credentials must have permissions to read/write/create.
  • Click OK.
SQL-RD Database Configuration Wizard.
  • The database is now being created within your own database server.
SQL-RD Database Configuration Wizard.
  • Click Finish when the process is complete.
SQL-RD Database Configuration Wizard.
  • SQL-RD is now configured to store the scheduling information in a database on your server.