SSRS report on SharePoint Web Part
- by MicroSumol
I have this configuration:
DBK- SQL/SSRS/SSAS (includes SharePoint databases)
SPK- SharePoint
I created a SharePoint Site with an SSL certificate. Then on DBK I setup the SSRS with an SSL.
Finaly went back to SharePoint and setup a webpart on a subsite to connect to the SSRS report.
The problem comes that the user is asked 2 times to authenticate. Once when he logs into sharepoint, then when he wants to see the SSRS report.
Since I am not an expert on SSRS, I am asking is there an easy way to pass the SharePoint credentials to the SSRS report. Would it be easier to install SSRS on SPK? Would that even work or solve my problem?