In the last post I show you how install Reporting Services. In this post I describe you how configure it.
Set connection to report server
First you have to run
Report Server Configuration Manager in
Start on Windows SO.
Report Server Connection appears. In the
Server Name field you see name your computer. The default
Report Server Instance is
Connect button. You see information about current Report server.
Configure new report database
Select from left side Database item. Next click the
Change Database button.
In the next step allow
Create a new report and click the
You see window like this below. Click the
Test Connection to check settings.
If the connection is OK, you see this information below. Click the
OK button into it.
And click the
After it, you see another step in configuration. Write in
Database Name name your database for reports. Mine is ReportServerDora.
Next button. In this moment you can select
Authentication Type. Default is
Service Credentials.I select
SQL Server Credentials.
I write user name to the database and password.
Next button.You see summary.
Next button.You have to wait for generate database.
Finish button.It is result it:
Configure Web Service URL.
Go to the Web Service URL section. Write name of
Virtual Directory for reports. Mine is ReportServerDoris.
Configure Web Portal URL.
Go to the Web Portal URL section and do the same as for Web Service URL. Write name for
Virtual Directory. Mine is ReportsDoris.
If you would like to see report go to the Web Portal URL and click the link.
You see authorization window. Write into it your login to your computer and password to your computer.
OK button. In the browser will be open clicked link.
Reports in SQL Server Management Studio
The configured report services you can see in SSMS. look at the screens.
Log into Reporting Services:
Log into Engine Database: