sql-server - 自动安装 SSRS

Question

我们如何使用 cmd/powershell 命令自动安装 Sql server Reporting services 2019？我试过跟随但它不起作用

>SQL2019-SSEI-Eval.exe /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /FEATURES=RS /RSINSTALLMODE="FilesOnlyMode" /InstanceName=MSSQLSERVER /RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /INSTANCEDIR="C:\Program Files\Microsoft SQL服务器”

标签： sql-serverreporting-services

Answer 1

使用 PowerShell 并假设您的安装程序是C :\SSRS中的Setup.exe

$pathvargs = {C:\SSRS\Setup.exe /q /IACCEPTSQLSERVERLICENSETERMS /ACTION="install" /ERRORREPORTING=1 /UPDATEENABLED="False" /INSTANCENAME="MSSQLSERVER" /FEATURES="RS" /RSINSTALLMODE="DefaultNativeMode" /SQLSVCACCOUNT="[DOMAIN\ACCOUNT]" /SQLSVCPASSWORD="[PASSWORD]" /AGTSVCACCOUNT="[DOMAIN\ACCOUNT]" /AGTSVCPASSWORD="[PASSWORD]" /SQLSYSADMINACCOUNTS="[DOMAIN\ACCOUNT]" }
Invoke-Command -ScriptBlock $pathvargs

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services-at-the-command-prompt?view=sql-server-2016#examples-of-本机模式安装