Microsoft SQL Server Reporting Services (SSRS) Implementation
Description
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. Administered via a Web interface, it can be used to prepare and deliver a variety of interactive and printed reports. Steps to be performed under this task: 1. Install SQL Server Reporting Services (if not existing); 2. Configure Report Server: 2.1. Set Service Account 2.2. Configure Web Service URL 2.3. Perform database connection 2.4. Configure Web Portal URL 2.5. Configure E-mail Settings 2.6. Set Execution Account 2.7. Configure Subscription Settings 3. Launch Web Portal 4. Configure Data Source 5. Configure User Access rights;
What will you get?
When the above steps are finalized you will be able to use the entire functionality of Microsoft SQL Server Reporting Services by creating and publishing your own reports. Once the reports are published the user can access them when they need or you can further create e-mail subscriptions so the reports will be delivered automatically by e-mail based on a predefined schedule.