How do I add SSRS Accounts in SQL-RD?

This is how you would associate your SSRS account(s) with SQL-RD. Associating your SSRS account gives SQL-RD access to reports you wish to schedule. SQL-RD will use stored credentials to access and export reports.

Integrations - SSRS Accounts

  • Go to View.
  • Select Integrations.

SSRS Report: Home Screen in SQL-RD.

  • Select SSRS Accounts.

SSRS Reports: Integration Library in SQL-RD

 

SSRS Reports: SSRS Accounts in Integration Library in SQL-RD.

  • Click Add.

SSRS Reports: Add an SSRS Account wizard in SQL-RD.

  • SSRS Account Name: Enter the name for the account.
  • SSRS Server URL: Enter the address of your reporting services server.
  • Domain\Username: Enter the domain and user for the SSRS Server URL.
  • User's Password: Enter password.
  • Server uses custom/forms authentication: Check this option if you are using SQL Azure Reporting Services.
  • Share this account with everyone: Check this option so all SQL-RD users can use this account.
  • Click Connect.

7-9-2019 9-56-41 AM

  • Click Save & Close.
  • The SSRS Account is now added to SQL-RD.