SQL databases, among many others, can also be used as a data source for report templates. To create a successful configuration, you can use the Basic Properties in the connection properties to define the individual elements for the access data:
In Expert mode, on the other hand, a so-called connection string is configured, which can be entered manually or used pre-configured (Management > Connection Strings):
Due to a technical adjustment with regard to security and encryption in version 29 of the Report Server, the following message may appear when testing the connection or when executing report templates that use such a data source:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)'
This may be the case if the configured SQL server does not use a valid SSL certificate, as is often the case for internal test purposes. In this case, the Encrypt parameter in the connection string can be temporarily set to false:
Important: It is recommended to use a valid SSL certificate for the SQL server.