question

DuncanStar avatar image
DuncanStar asked

Is it possible to upload user credentials with an SSRS RDL file?

I have dozens of SSRS reports that all use a custom data source. This allows me to pass the Server and Database names as parameters. Problem is, when the RDL files are uploaded, there are no user credentials. The credentials are uploaded if I save the reports using Report Builder, but I dont want to have to do that for dozens of reports, I was hoping for a more automated process. I have tried the RS utility with no success. I have also tried writing the user name and password to the DataSource table on the server using the HASHBYTES function in SQL, but to not avail. Any ideas?

Thanks

Duncan

ssrs-2012rdl
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.