SQL Report Server: No DSN present in configuration file

/ Ike Ugochuku

After you have installed or added a report server to SQL, the report server is not yet setup. You still have to do the following to complete the setup.

  1. Open the Reporting Services Configuration Manager
  2. Go to the Database section in the Menu and add a database to be used by the Reporting service
  3. On the same page enter the Reporting database credential
  4. Go to the web service url and specify the name of a virtual directory and a TCP port to be used. Do not use a port that is already in use, e.g port 80 may be already used by Sharepoint or MIM Portal.
  5. Go to the reportmanager url and specify a virtual directory name to be used.

Leave a comment