We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to validate ReportDatasource ConnectionString?

Report DataSource connection string can be validated by using the following utility for the ReportViewer.
http://www.syncfusion.com/downloads/support/directtrac/137390/DataSourceConnectionTest-449402439.zip

Refer to the step-by-step procedure to validate the connection string by using the above utility.

  1. Initial page of the application is as follows.

Figure 1: Initial Application page

  1. Choose the connection type.
  2. Integrated security needs to be checked for trusted connections (Windows authentications).
  3. When the connection string contains username and password, then the Authentication checkbox needs to be checked and valid login details filled in the desired fields.
  4. Click the test connection option to validate your connection string.
  5. Connection status is displayed in a message box. When there are errors, the details of the errors are shown along with descriptions.

Note: When the DataSource is a shared DataSource, then the username and password details must be given in connection string itself to validate the connection. (For example, DataSource=191.234.40.112; Initial Catalog=AdventureWorks; user ID="ssrs1"; password="RDLReport1";)

Figure 2: Application with connection details

Figure 3: Connection status

Article ID: Published Date: Last Revised Date: Platform: Control: .NET Framework: Product Version:
4982 05/23/2015 05/23/2015 LightSwitch HTML ReportViewer 4.5.1 12.4.0.24
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.