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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to validate ReportDatasource ConnectionString?

Platform: LightSwitch HTML |
Control: ReportViewer |
Published Date: May 23, 2015 |
Last Revised Date: May 23, 2019 |
.NET Framework: 4.5.1 |
Product Version: 12.4.0.24

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.

Initial page

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.

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";)

 

Connection Details

Figure 2: Application with connection details

Connection Status

Figure 3: Connection status

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon