2

I am trying to create a SharePoint Server environment. I have an Azure subscription, so I created a Windows Server 2019 virtual machine and set up Active Directory. I also created an Azure SQL Database server (mysql.database.windows.net). I downloaded SharePoint Server on to the Windows virtual machine, and I tried to connect it to the Azure SQL Database, but it said Windows Authentication was not supported.

Is it possible to use an Azure SQL Database Server for SharePoint Server?

Improve this question

2 Answers 2

Reset to default
2

Did you follow these instructions:

https://docs.microsoft.com/en-us/sharepoint/administration/deploy-azure-sql-managed-instance-with-sharepoint-servers-2016-2019

Improve this answer
2

According to the official document, you need to host the databases on Azure SQL Managed Instance with SQL authentication.

One more reference for you: Hosting SharePoint Content Databases in SQL Azure.

Improve this answer
2
  • How do I connect with SQL authentication? In the product configuration wizard, there is no option to change the authentication type, and in PowerShell, it will only accept a PSCredential.
    – Ralph Greene
    Jul 14, 2020 at 14:12
  • @RalphGreene According to the document (first link), the databases on SQL MI should be hosted with SQL authentication, but you will need SharePoint farm service account credential in PowerShell/SharePoint Products Configuration Wizard, and Azure SQL Managed Instance database login credential in the section “DatabaseCredentials”.
    – Chelsea_MSFT
    Jul 15, 2020 at 2:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.