Installing SharePoint 2019 using Azure Sql Managed Instance

brianlala / AutoSPInstaller

Automated SharePoint 2010/2013/2016/2019/SE PowerShell-based installation script.

https://autospinstaller.com

MIT License

171 stars 81 forks source link

Installing SharePoint 2019 using Azure Sql Managed Instance #61

Closed IfEyeOnlyKnew closed 4 years ago

IfEyeOnlyKnew commented 4 years ago

Installing SharePoint 2019 using Azure Sql Managed Instance, but getting this issue: Testing access to SQL server/instance/alias: sqlname.database.windows.net

Trying to connect to 'sqlname.database.windows.net'
Using connection string 'Server=sqlname.database.windows.net;Integrated Security=SSPI;'...Failed

I am assuming my error is or could be that our accounts are local AD accounts and not Azure Active Directory accounts.

jeefberkey commented 4 years ago

Make sure you have updated your sharepoint instance... https://docs.microsoft.com/en-us/sharepoint/administration/deploy-azure-sql-managed-instance-with-sharepoint-servers-2016-2019

brianlala commented 4 years ago

At this time, only SQL authentication is supported for connecting to SQL MI from SharePoint.