Monday , September 25 2017
Home / MSSQL DBA / Configuring SQL Server Report Server and Environment

Configuring SQL Server Report Server and Environment

Basic Steps for Junior Level DBA’s
Configuring SQL Server Report Server and Environment
First Step: – Open > Reporting Services Configuration Manager
For Customize the Setting, Click connect Button
Next > Service Account
keep any account depends upon your project And Apply
Next> Web Service URL
In this we can set Virtual Directory and If required we can Set SSL or No need.
Web Url will open in IE or Firefox browsers.
Once completed.
Click Apply
Next> Database
Changing database
Here I am choosing existing report Server database and Next
Here We can choose Current User or SQL Server Account
Test Connection. For testing the connections for SQL Server instance.
Select ReportServer 2008 database avoiding Default Database (ReportServer$EUEPRD)
Click Next:-
Note:- Make Sure all objects are replicate like default database ReportServer$EUEPRD
Here I am choosing SQL account with sa login
Click Next:-
Here found servername, database name , Login Account details “sa” and password.
Click Next:-
Create Temp database named as “ReportServer2008TempDB” and rexucute. Click Finish
Report Manager URL.
Here we can set Email and Smtp Server name.
Click Apply:- Applied email settings and Execution Account as per project requirement, I am using sa login.
Encryption Keys setting, I am using default. If any sensitive data we can enable. Mostly this is using in banking domain projects.
Scale-out Deployment:-
Final deployment have a look
Completed the Setting:-
Opening the Web URL in Internet Explorer
Done it’s completed.
We can found Home, Data source, report builder and upload file etc.
Sample report I am uploading and Press Ok
Happy Reading
Read More:
The Inside Secrets Of Millionaires Under The Age Of 29
Scientist Finds Breakthrough Weight Loss Formula!
New! A Stain Remover That Works Like Magic



Check Also

SQL Server Error Logs

SQL Server Error Logs Detailed Information

SQL Server Error Logs * Error Logs maintains events raised by SQL Server server or …

Leave a Reply

Your email address will not be published. Required fields are marked *