Wayne Snyder posted on February 26, 2008 11:27
Purpose
The scope of this document is to address the questions and provide best practices related to creating Data Sources for SQL Server Reporting Services (“SSRS”).
When requesting the creation of a Data Source for SSRS, the requestor must make several decisions regarding the configuration of the data source. This document covers those decisions and provides information and advice for the decision maker.
Overview
The SSRS data source defines a connection to data as a string of text stored either in the report definition file or in a separate data source file which can be shared among several reports. SSRS supports data sources that include most databases accessible with ODBC connectivity and all OLE DB providers.
The developer will provide the following information:
Work Header Information
- Add Data Source:
- Change Existing Data Source:
- Data Source Business Area
- Data Source Environment
- Development
- System Test
- Quality Assurance
- Production
- All
- Name/Folder Name/Location for New/Existing Data Source
- Specify name of Data Source
- Specify Folder location for Data Source
- Specify Server name for Data Source
Add/Change Data Source Details(see actual Reporting Services form below)
Note: If you are requesting for more than one environment (Dev, System Test, QA, Production), the following information must be provided for each environment, unless all of the details are the same.
.
- Data Source Description: (Must include contact information for support, formatted as follows )
- Support: (Place a pager/email group. If no pager/email group, then Person name, email, phone, and Alternate Person name, email and Phone)
- Data Access: (Only if different from above, place a pager/email group. If no pager/email group, then Person name, email, phone, and Alternate Person name, email and Phone)
- Hide in List View: Yes/No
- Enable this Data Source: Yes/No
- Connection Type:
- Microsoft SQL Server
- Oracle
- DB2
- OLE DB provider
- ODBC
- Microsoft SQL Server Analysis services
- XML
- Report Server Model
- Connection String(Depends on Data Source)
- Database Name on the Specified Server (if applicable)
- Server name(URL) where database(File) is located (Optional-based upon type of data source)
- Connect Using:
- Windows Integrated Security
- Credentials Stored Securely in the Report Server
- Process Id
- Password
- Use as Windows Credentials when connecting to the data source: Yes/No
- Impersonate the authenticated user after a connection has been made to the data source: Yes/No
- Credentials Supplied by the user running the Report
- Display text to prompt user for user name and password:
- Use as Windows Credentials when connecting to the data source: Yes/No
- Credentials are not required.