Skip to main content
Question

SSRS Extension DLLs not configured as WIA for Operational Reports


Forum|alt.badge.img+7
  • Do Gooder (Employee)
  • 17 replies

when SSRS Extension is installed for Database Authentication  or LDAP; The IFS SSRS DLL for IFS Operational and Quick Report are installed. 

Created New SSRS Site installed IFS SSRS Extension using WIA authentication option. The IFS SSRS Extenstion DLLs for Quick Report was installed and NO dlls was configured for Operational Report.

 

Is this a bug?

 

Regards

Salman 

4 replies

ChanakaAmarasekara
Hero (Employee)
Forum|alt.badge.img+15

Hi,

Have a look at the SSRS documentation for SSRS Operational Reports below,

https://wit.ifsworld.com/f1docs/apps10/Foundation1/050_development/025_operational_reporting/210_ssrs_as_operationalreport/default.htm#Known_Limitation

Known Limitation

  • SSRS Data Service Extension does not support Windows Integrated Authentication

Regards,


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Employee)
  • 17 replies
  • April 22, 2020

Hi Chanaka;

Thank you for your response.  

Is it possible to use Apps10 SetupIFSReportDataExtension.exe  instead of Apps9 SSRS Extension for WIA configuration?

 

Regards

Salman

 


ChanakaAmarasekara
Hero (Employee)
Forum|alt.badge.img+15
SASIUS wrote:

Hi Chanaka;

Thank you for your response.  

Is it possible to use Apps10 SetupIFSReportDataExtension.exe  instead of Apps9 SSRS Extension for WIA configuration?

 

Regards

Salman

 

As the documentation says SSRS Operational Reports doesn’t support WIA both in APPS9 and APPS10.

 

https://wit.ifsworld.com/f1docs/apps9/Foundation1/050_development/025_reporting/010_operational_reporting/210_ssrs_as_operationalreport/default.htm#Known_Limitation


ctaylor56
Hero (Partner)
Forum|alt.badge.img+14
  • Hero (Partner)
  • 163 replies
  • November 25, 2020

We were able to get around this.  Customer was using Azure Authentication login into IFS.  WIA was setup for SSRS server (NTLM).  When a domain PC ran a SSRS quick report, there would be no prompt to log into the SSRS server.  However we would get a 401 error when running an operational report.  If we switched SSRS server to basic authentication, Operational Reports would work but quick reports prompted for log in.  

 

Solution, add Basic AND NTLM authentication to report server config file.  Gets rid of 401 error for operational reports and users on domain PC’s do not have to reauthenticate to run a quick report.

 

<Authentication>

                                <AuthenticationTypes>

                                                <RSWindowsBasic/>

                                                <RSWindowsNTLM/>

                                </AuthenticationTypes>

                                <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>

                                <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

                                <EnableAuthPersistence>true</EnableAuthPersistence>

                </Authentication>


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings