Category / Section
How to validate reportdatasource connectionstring?
1 min read
Report DataSource connection string can be validated by using the following utility for the ReportViewer.
https://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.
- Initial page of the application is as follows.
Figure 1: Initial Application page
- Choose the connection type.
- Integrated security needs to be checked for trusted connections (Windows authentications).
- 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.
- Click the test connection option to validate your connection string.
- 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";) |
Figure 2: Application with connection details
Figure 3: Connection status