We have a WebApp with a few reports. They work fine when used on the development machine, but can't connect to the SQL server when run on the webserver.

For development we use an SQL server on localhost with a trusted connection. The webserver uses password authentication and connects to an instance on another server. The WebApp itself runs fine, but the report can't connect to the SQL instance.

I opened the report and switched the SQL connection to the proper SQL instance and then copied the report file to the server. It works on my machine (with the productive SQL instance and password authentication) but when I copy the report to the server it still can't connect.

I was hoping to avoid installing the report editor on the server and I don't like to use DSN if possible (-> https://www.microsoft.com/en-us/micr...e-connections/ )
Is there a way to tell the report to use the same connection string/ authentication as the WebApp does? If so, how?