azure - Powershell 脚本 |在 Sharepoint 2019 中创建新的 Web 应用程序

Question

有人可以分享在 Sharepoint 2019 中使用 SQL SA 身份验证创建新 Web 应用程序的 powershell 脚本吗？我发现很多脚本只与 SQL Server 的 Windows 身份验证对话，但我有 Azure 托管 SQL 实例与 Sharepoint 服务器 2019 链接。

请帮忙。

Answer 1

通过进行一些研究，我得到了工作脚本:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue 
#Define Variables for Web Application Creation
$WebAppName = "abc.xyz.com" 
$WebAppURL = "http://abc01"
$WebAppPort = 9000
$ContentDBName = "WSS_Contents_Abc"
$AppPoolName = "SPABC"
$AppPoolAccount = "Test\ABC"
$DatabaseServer = "sql-managedinstance-902932test.net" #Alias of your DB Server
#Authentication Provider
$AuthProvider = New-SPAuthenticationProvider -UseWindowsIntegratedAuthentication 
-DisableKerberos $FarmAccountLogin = "Test\ABCSQL";
$FarmAcountObj = Get-Credential -Credential $FarmAccountLogin; 
#Create new Web Application
New-SPWebApplication -name $WebAppName -port $WebAppPort -URL $WebAppURL - 
ApplicationPool $AppPoolName -ApplicationPoolAccount (Get-SPManagedAccount 
$AppPoolAccount) -AuthenticationMethod NTLM -AuthenticationProvider 
$AuthProvider -DatabaseServer $DatabaseServer -DatabaseCredentials 
$FarmAcountObj -DatabaseName $ContentDBName