Working with SSRS Reporting Services Configuration Manager
SSRS Configuration Manager
Generally, this tool is available for administrators to configure the reporting services components and items
If you would like to become an SSRS (SQL Server Reporting Services) certified professional, then visit Mindmajix - A Global online training platform:"SSRS training and Certification Course". This course will help you to achieve excellence in this domain.
Navigation:
START → PROGRAMS → CONFIGURATION TOOLS → REPORTING SERVICES CONFIGURATION MANAGER.
1) Service Account: It specifies or takes built –in Account (or) windows domain user account to run the report server service
2) Web Service URL:
This is report server URL, if we want to change we can change it
Virtual directory: Report server
Click apply
Default URL :- https:// : / Report server name>
3) Report Manager URL:
Default URL:- hhtp://:
Eg: Error! Hyperlink reference not valid.> : <8080> / Report_DWH.
4) Databases:
It takes and displays report server data bases
Default: Report server DB.
Report server Temp DB.
Navigation:
Start à programsà sql server 2008 à management studio à database engine à
New database creation:
Change databaseà nextà servername: Localhost à Database name: Report server )DWH à Next à next à finish.
5) Email Settings:
These settings are useful, required at the time of subscription and delivery it requires below settings
Sender address: MSBI VIMY@GAMIL.COM
Current SMTP delivery: USE SMTP server method
SMTP server : 127.0.0.1 click Apply
Note:-
From the specified mail ID on the specified server the mail sent to the corresponding recipients.
Frequently Asked MSBI Interview Questions & Answers
6) Scale Out Deployments:
In Real time these are two types
- Single server deployment à Report server and database on same machine
- Scale out deployment à Report server and database on different machines
Scale Out Deployment:.png&w=16&q=75)
Explore SSRS Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!
List of Related Microsoft Certification Courses:
| SSIS | Power BI |
| SSAS | SQL Server |
| SCCM | SQL Server DBA |
| SharePoint | BizTalk Server |
| Team Foundation Server | BizTalk Server Administrator |
Job Support Program
Online Work Support for your on-job roles.
Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:
- Pay Per Hour
- Pay Per Week
- Monthly
| Name | Dates | |
|---|---|---|
| MSBI Training | Dec 24 to Jan 08 | View Details |
| MSBI Training | Dec 28 to Jan 12 | View Details |
| MSBI Training | Dec 31 to Jan 15 | View Details |
| MSBI Training | Jan 04 to Jan 19 | View Details |
Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.
- MSBI Career Opportunities
- MSBI Interview Questions
- MSBI Interview Questions
- Action Properties Dialog Box (Report Builder and SSRS) - MSBI
- Best Practices for Performance Tuning in SSAS Cubes
- Conformed Dimension in SSAS with Example
- Data Warehousing Concepts in SSIS
- How To Debug SSIS Packages in SQL Server
- How to Access Report Manager in SSRS 2012
- How to Create Cube in SSAS with Example
- How to Create Drill Down report in SSRS 2008
- How to Create Table Report in Reporting Services - MSBI
- How to Implement Proactive Caching in SSAS - MSBI
- How to Publish Report to a Report Server in SSRS
- Checkpoints in SSIS
- Incremental load in SSIS with example
- Introduction to SQL Server Analysis Services
- Learn to Write MDX Queries in Analysis Services (SSAS)
- MSBI Advantages and Its Data Evaluation Stages - MSBI
- Named Query & Named Calculation in SSAS
- Normalization and T-SQL in SQL Server
- Passing Parameters to a report in SSRS
- Report and Group Variables in Reporting Services - MSBI
- Reporting Services Configuration Files – SSRS
- How to Set Transaction Isolation Level in SQL Server
- SQL Server 2008 R2 – LookUp Enhancement in SSRS
- SQL Server Analysis Services Aggregation Designs
- Partitions In SSAS
- SQL Server Data Modeling
- SQL Server Performance Tuning Tips and Tricks in MSBI
- SQL Server Reporting Services Performance Tuning - MSBI
- SSAS Analysis Services Cube Deployment Methods
- SQL Server Integration Services – SSIS Architecture Overview
- Step by Step MSBI Installation and Requirements - MSBI
- Step by Step SSIS Package Deployment
- TextBox Properties in SSRS 2008
- SSIS Control Flow
- Working with Data Flow Task in SSIS Packages
- Working with Report Models in SSRS
- T-SQL Interview Questions