The server name and database are passed in as parameters to the report and used in the connection string. However, we are using the same sql account for authentication across servers. We could not use Windows auth due to an NTLM double-hop issue.

The thing I find interesting about this problem is if I deploy a report directly to the server via BIDS all of the credential information is maintained. So it is certainly possible to transfer a report with embedded datasources and maintain the credentials. So what is BIDS doing to keep the credentialling info that RS Scripter isn't?