SharePoint 2019/Subscription Edition -- SQL Authentication

Question

I almost always installed SharePoint in a domain environment where the Application Server(s) and Database Server(s) were within the same AD domain.

I am increasingly seeing use cases where SharePoint could/should be in a DMZ and simply having SharePoint utilise a SQL server cluster (deployed in a different domain, for example) and having SharePoint connect to SQL using SQL Authentication.

In previous versions of SharePoint Microsoft's support for that was always grey. The "support" was typically limited to a subset of services (e.g. a Content DB). And the wider SharePoint farm (and services) still needed to be deployed within the same domain at the SQL server. Does anyone know if that is still the case?

And if not, can you point me to some documentation/article that outlines how to install SharePoint 2019 (or Subscription Edition) where all of SharePoint is authenticating to its SQL backend using SQL Authentication (rather than Windows authentication)?

Answer 1

Hi @Timothy A. Dilbert ,
According to my research, there is currently no official documentation to support this.
For security reasons, it is still recommended that you use Windows Authentication.

For more details, please refer to here.
However, I found an article that may be useful to you, you can refer to it.

https://www.qualys.com/docs/qualys-authenticated-scanning-microsoft-sharepoint.pdf
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Thanks,
Yanli Jiang
*
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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

Hi @Timothy A. Dilbert ,
Unfortunately , based on my research, currently OIDC authentication can only be configured in SharePoint Subscription Edition. Please refer to this.
It is recommended that you use windows authentication.
To address your concern about the situation, we’d suggest you go to feedback on this issue, this is the best platform to let us hear from you and make our products and services better for you and others.

Thanks,
Yanli Jiang
*
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.