After you have installed SQL Server Reporting Services 2017, you will need to configure SSRS before you can use it. Go to Reporting Services Configuration Manger to configure SSRS.

Reporting Services Configuration Manager

  • Configure the Web Service URL tab and hit Apply to create directory in IIS.
  • Configure the Web Portal URL tab and hit Apply to create directory in IIS.
  • Configure the Database tab. You can create new report database or connect to existing one. If you do not configure the database tab, you will get the “No DSN present in configuration file” error in the log file.

Reporting Database

  • ReportServer
  • ReportServerTempDB

Logs

C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles

Last modified: April 9, 2020

Author

Comments

Write a Reply or Comment