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. Commented 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”. Commented Jul 15, 2020 at 2:18

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.