Hi There,
I was hoping someone could help me with the following issue that we have in our implementation.
Scenario:
The following products are installed in the environment:
- AX 2012
- Sharepoint 2010
- SQL 2008 R2 with CU3
The current AX 2012 implementation requires external users (non active directory users) to log in to the AX 2012 Enterprise Portal to view their details over the internet. The details include viewing sales invoices and some SSRs reports relevant to their transactions. Enterprise portal has been configured with Forms-based Authentication (HTTPS://). We have an ASP.Net database that hosts the user names and passwords of all the external users.
Issue:
The problem occurs when these external users would like to view the SSRS reports via the Enterprise Portal. I did read that the issue is due to the fact that SQL SSRS is configured (by default) with HTTP but if users want to view reports over HTTPS websites, additional configuration is required on SSRS and possibly Sharepoint as well. I came across various blogs discussing how to view SSRS reports via the internet but am not sure what approach is the best.
Some of the suggestions included to
- Set up Custom Authentication on SSRS
- Set up SSRS in Sharepoint integrated mode as opposed to Native mode
I would appreciate your suggestions on how to configure SSRS if you have dealt with the above or have some suggestions on how best to go about this.
Thanks
Tarun
