Question

SSRS Extension DLLs not configured as WIA for Operational Reports

  • 21 April 2020
  • 4 replies
  • 224 views

Userlevel 3
Badge +7
  • Do Gooder (Employee)
  • 14 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

Userlevel 7
Badge +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,

Userlevel 3
Badge +7

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

 

Userlevel 7
Badge +15

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

Userlevel 5
Badge +14

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