Post reply

SSRS Connection String

  • March 31, 2009 at 10:13 am

    #202382

    I have created a report and I am giving connection string at design time but I want to deploy the same report for

    different servers.like developing server ,testing server,

    production server

  • March 31, 2009 at 10:17 am

    #969259

    That is very easy with shared datasource because you are just running different SSRS instances with either same datasource database or different copies of the database.

    If this is a large project with more than five developers then just use three copies of the shared datasource database, development, test and production.

    Kind regards,
    Gift Peddie

  • April 1, 2009 at 12:05 am

    #969631

    shared datasource is good option or you can define one internal parameter in the report and pass the server information to that parameter through your application.

    in this way when you deploy the application for various server it will automatically take the server information from your config file which is passed through UI.

  • September 23, 2010 at 12:23 pm

    #1226528

    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!

  • September 23, 2010 at 12:33 pm

    #1226534

    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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply