• DucatiRider (9/23/2010)


    Hi, I saw this post and am interested in the topic. I 'm a newbie to SSRS and am exploring how I can dynamically change the connection string. We have a report built in our DEV environment but when it's moved over to our QC and prod environments, (by someone else) we'd like to change the connection to different servers done without the promoter having to modify any code.

    Is there a way to do this?

    thanks!

    If it is a shared datasource using SQL Authentication then no but if it is not Shared datasource then permissions needs to be changed to show whose permission is used to connect to the datasource database and SSRS.

    Kind regards,
    Gift Peddie