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

1. Single server deployment à Report server and database on same machine
2. Scale out deployment à Report server and database on different machines

 

Scale Out Deployment:

 

Explore SSRS Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!

List of Related Microsoft Certification Courses: