SSRS Report Server
SQL Server Reporting Services (SSRS) is a server based scalable and extensible platform for authoring, deploying, executing and managing reports based on a variety of data sources.
Configuring SSRS Report Server
Click on Microsoft SQL Server 2012 Program Folder from the Start Menu.
Click on the connect button.
Click on Service Account option in the Left pane, here you have the option for choosing a built-in account or windows domain user account to use the Report Server Service.
Click on the Web Service URL option – this URL will be used to host and access the report server. Give the report server a name in the Virtual Directory option. Then, click on the apply option and your URL will be converted into a hyperlink, as shown below
The option Database, is for the Report server database. It is used for Meta data of reports. Click Change Database button on right pane and another window will open. You may opt for either an existing database or create a new database, then click on next.
Now, enter the database server name which you want to connect to, and then click on next button.
Now, you have to enter a name for the Report Server Database that will be used for storing Meta Data for the Report Server. After selecting the appropriate options that you need, click on the Next button. The Report database will be created.
Interested in mastering SSRS Training?
Learn more about SSRS Tutorial in this blog post.
You may check your Report server database in the SQL Server IDE, as shown below.
Now, you are almost done with all the needed basics for starting to your SSRS sever.
You can now access your SSRS Report server using the URL “http://localhost/Reports/Pages/Folder.aspx”. The following page will be displayed in your browser:
For indepth understanding click on