> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft Reporting Service Connector

## Intro

Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools to create, manage, and deliver reports, and APIs that enable developers to integrate or extend data and report processing in custom applications. Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components. To learn more about the SQL Server Reporting Services, visit their page ([https://docs.microsoft.com/en-us/sql...inated-reports](https://docs.microsoft.com/en-us/sql/reporting-services/create-deploy-and-manage-mobile-and-paginated-reports "https://docs.microsoft.com/en-us/sql/reporting-services/create-deploy-and-manage-mobile-and-paginated-reports") ).

You connect to your Microsoft SQL Server Reporting Service account in the Data Center. This topic discusses the fields and menus that are specific to the Microsoft Reporting Service connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in [Adding a DataSet Using a Data Connector](/s/article/360042926274).

## Prerequisites

To connect to your Microsoft SQL Server Reporting Service account and create a DataSet, you must have the following:

* The report service URL
* The username and password that provide access to the SQL Server Reporting Service

## Connecting to Your Microsoft SQL Server Reporting Service Account

This section enumerates the options in the **Credentials** and **Details** panes in the Microsoft Reporting Service Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in greater length in [Adding a DataSet Using a Data Connector](/s/article/360042926274).

### Credentials Pane

This pane contains fields for entering credentials to connect to your Microsoft SQL Server Reporting Service account. The following table describes what is needed for each field:

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p> Field </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"> Report Service URL </td><td colspan="1" rowspan="1"> Enter the report service URL. </td></tr><tr><td colspan="1" rowspan="1"> Username </td><td colspan="1" rowspan="1"> Enter the username to access the SQL Server Reporting Service. </td></tr><tr><td colspan="1" rowspan="1"> Password </td><td colspan="1" rowspan="1"> Enter the password to access the SQL Server Reporting Service. </td></tr></tbody></table>

Once you have entered valid Microsoft SQL Server Reporting Service credentials, you can use the same account any time you go to create a new Microsoft Reporting Service DataSet. You can manage Connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Managing User Accounts for Connectors](/s/article/360042926054).

### Details Pane

This pane contains menus for selecting and configuring the report and its parameters.

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p> Menu </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"> Report Path </td><td colspan="1" rowspan="1"> Select report from the list. </td></tr><tr><td colspan="1" rowspan="1"> Parameters </td><td colspan="1" rowspan="1"> Select parameter(s). </td></tr><tr><td colspan="1" rowspan="1"> Parameters Helper </td><td colspan="1" rowspan="1"><p> To modify query, please replace the placeholders with the appropriate values. </p><p> Example: Property1=Value1;Property2=Value2;...Propertyn=Valuen </p></td></tr><tr><td colspan="1" rowspan="1"> Input Parameters </td><td colspan="1" rowspan="1"> Enter the query in the form Property1=Value1;Property2=Value2;...Propertyn=Valuen. You can refer it from Parameters Helper. </td></tr></tbody></table>

### Other Panes

For information about the remaining sections of the Connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Data Connector](/s/article/360042926274).