SharePoint Form Based Authentication and SSRS data source

Question

I have SharePoint 2016 Web Application with Claims Authentication (using NTLM).

When I try to create "SharePoint List Data Source) as Embedded Data Source in Report Builder or Shared Data Source in SSRS Portal - everything is working fine. I'm using dedicated AD account, which is owner of the SharePoint Site.

Then I try to implement both, NTLM and Form Based Authentication to my SharePoint Web Application. Everything in SharePoint site is working fine and I can log in with AD accounts and FBA accounts.

But, trying to create SharePoint List Data Source (with the same AD account as usual) I get error: "Server was unable to process request. ---> Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))"

Intentionally, I tried to connect with wrong password and I got: "Log on failed. Ensure the user name and password are correct."

So, my questions are:

1. Is it possible to connect from SSRS to SharePoint 2016 list using NTLM authentication (AD user), when there (in SharePoint Web App) are working both authentication methods: NTLM and FBA?
2. If yes, what am I doing wrong? What setting did I miss?

Answer 1

Hi @Matus Corny

There are quite a few situations where applications don't talk nicely to web apps with both authentication methods enabled.

In addition, as far as I know, at this time a Web application that is using Claims Based Authentication with Forms Based Authentication (FBA) enabled is not supported.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

@Itch Sun-MSFT , Thank you for you answer.

At first, I've read the documentation: sharepoint-list-connection-type-ssrs

and I thought, that while I'm using "Claims-based SharePoint site" (Table 2) and "combination of more than one of the above mentioned authentication providers." (asterisk) - that's why I thought, that what I'm going to do is supported.

Am I missing the point (or idea) of Microsoft documentation?

There is explicitly written text: "Forms-based authentication and Claims authentication are not supported for remote SharePoint lists.", but for Local farm SharePoint list is just "Yes".

Sorry, I'm not native english speaker, maybe that's why I'm confused and don't know, what's supported and what's not.