Creating an SSRS Data Source Connection

Follow

If Atlas is hosting your report services we will create your data source connection for you. If you are self-hosting reports you will need to complete this step as part of your setup.

Before you can create and run reports, you must establish the source of your data by pointing the SSRS server to your SQL server.

  1. From within your institution folder, accessed via the web, click New Data Source on the main menu.
  2. The New Data Source screen displays.
  3. After entering the necessary information click OK.
  4. Click Test Connection if you want to test the server connection first.
  5. You are now ready to create and run reports.

The "Connection String" Field

When pointing to a production version of SQL Server, the connection string format is: Data Source=123.123.123.123;Initial Catalog=AeonData

The "Connect Using" Options

When the report server connects to the data source, it is using the read-only account you created to access the data.

  1. Click Credentials stored securely in the report server and enter that Username and Password.

Understanding Data Sources and Datasets

Opening one of the basic reports, for example, Visits Per Day, you will notice that the Report Data column on the left side of the form includes entries for Data Sources and DataSets. The data source is the connection to your database. All reports must have a data source entry. Datasets are the saved queries that have been created for a saved report based off of the data source.

When you create new reports, you will configure your data source and dataset information for that particular report. Report Builder comes with a built-in library of information to assist you with creating reports.

If you are hosted, the Data Source and Dataset entries for the basic reports have been configured for you by Atlas Systems.


Questions?

If this article didn’t resolve your issue, please take a moment and answer a few questions to help improve our documentation:

Feedback