Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
sharepoint SSRS authenitication for seeing the reports

Answered sharepoint SSRS authenitication for seeing the reports

  • Wednesday, May 23, 2012 10:15 PM
     
     
    Sign In to Vote
    0

    HI Team,

    I would like to know best way how we can configure sharepoint to SSRS about authencation to see the reports  when the sharepoint intregration mode is "Trusted"?.

    I can able to see the SSRS reports in sharepoint site when it is windows integrated. (i.e Sharpeoint repoort  integration mode is "windows").

    Right now the managers want that authentication mode is  "Trusted mode" but not "Windows". 

    So  How we can see the reports if the authentication mode is "Trusted" ?

     Please help me its very urgent

    Regards,

    Ramu

     

All Replies

  • Thursday, May 24, 2012 1:25 AM
     
     Answered
    Sign In to Vote
    0

    In trusted mode, you will set up connections to use a proxy account. The account that is used can be either Windows or SQL, depending on the option that you choose. You will then configure your reports to use one of these connections.

    It is a good practice to keep the connections in a separate library from the reports, and to secure them appropriately, since editors will be able to see the connection strings. Also, the accounts used as proxies should only have permissions to the items in SQL required to render the reports.

    I hope that this helps.

    John

     
  • Thursday, May 24, 2012 10:15 PM
     
     
    Sign In to Vote
    0

    Hi John,

    Thanks for the reply.

    Iam new to the sharepoitn 2010.

    Can you please let me know how to set up connections to use proxy account ?..

    And one more doubt is ..

    One my team mate is saying that use secure store credentials (updating the data source definition). So i given my credentails in secured store and then its working fine. but moy doubt is i given my credentails statically in my machine but how it can be resolved in production envirionment ?..

    Regards,

    Ramu

     
  • Thursday, June 07, 2012 6:23 AM
     
     
    Sign In to Vote
    0

    Hi rajsp2010,

    I suggest you open a new thread for the rest questions.

    Thanks,

    Rock Wang

    Rock Wang TechNet Community Support