Wednesday, May 23, 2012 10:15 PM
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
Thursday, May 24, 2012 1:25 AM
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.
- Marked As Answer by Rock Wang– MSFT Thursday, June 07, 2012 6:22 AM
Thursday, May 24, 2012 10:15 PM
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 ?..
Thursday, June 07, 2012 6:23 AM
I suggest you open a new thread for the rest questions.
Rock Wang TechNet Community Support