Create a user that have access to read and modify reports and connections. Then user can use the Standalone Report Designer tool to create reports, where the designer tool must be connected to the server.
On designing a report, the user can add a SqlDataSource component configured with a connection string of choice. Saving the connection string by name, will set the SqlDataSource.ConnectionString to the name of the connection string.
On publishing the report, the connection string will be saved on the server under Data. In case the connection string is not valid when used by the Report Server, the user can open the Admin module >Data tab and edit the saved connection string - only the name must remain the same to avoid issues on displaying the report.
If I am misunderstanding the question, please open a support ticket and send us a video illustrating the described steps and the issue.
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items