SQL Report Server: No DSN present in configuration file

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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s