Microsoft SQL Server 2012 Powershell安装“SQLSERVERAGENT”错误(Microsoft SQL Server 2012 Powershell instal

Microsoft SQL Server 2012 Powershell安装“SQLSERVERAGENT”错误(Microsoft SQL Server 2012 Powershell install 'SQLSERVERAGENT' error)

我正在尝试通过Powershell在本地安装SQL Server 2012并继续遇到错误：

The following error occurred: The credentials you provided for the 'SQLSERVERAGENT' service is invalid. Error result: -2068578304 Result facility code: 1204 Result error code: 0

以下是执行安装的简单行。

&'D:\FilePath\setup.exe' /QS /ConfigurationFile=C:\FilePath\ConfigurationFile.ini

在ConfigurationFile.ini中，以下内容：

SQLSVCACCOUNT="HT\SqlSrvBK" SQLSVCPASSWORD="P@ssWord!@#$"

对于ConfigurationFile.ini来说还有更多，但它们是与我认为的问题相关的主线。

我也试过直接传递密码，例如：

&'D:\FilePath\setup.exe' /QS /ConfigurationFile=C:\FilePath\ConfigurationFile.ini /SQLSVCPASSWORD="P@ssWord!@#$"

还试过从Powershell获取它作为字符串或安全字符串，并转义任何将被提出的符号，如“$”。 我肯定密码是正确的，因为通过GUI运行该过程100％的时间。 我的环境在Windows服务器2012上，与VMware一起运行。 我尝试过本地管理员帐户以及域管理员帐户。 感谢您提出任何建议和/或帮助。

I'm trying to locally install SQL Server 2012 via Powershell and keep running into the error:

The following error occurred: The credentials you provided for the 'SQLSERVERAGENT' service is invalid. Error result: -2068578304 Result facility code: 1204 Result error code: 0

The following is the simple line for executing the install.

&'D:\FilePath\setup.exe' /QS /ConfigurationFile=C:\FilePath\ConfigurationFile.ini

In the ConfigurationFile.ini the following:

SQLSVCACCOUNT="HT\SqlSrvBK" SQLSVCPASSWORD="P@ssWord!@#$"

Granted there's more to the ConfigurationFile.ini but they are the main lines related the the issue I believe.

I have also tried to pass the password in directly such as:

&'D:\FilePath\setup.exe' /QS /ConfigurationFile=C:\FilePath\ConfigurationFile.ini /SQLSVCPASSWORD="P@ssWord!@#$"

Also tried is getting it from the Powershell as a string or a secure string and escaping any symbols that would get fileted out such as "$". I'm positive the password is correct as running the process via the GUI works 100% of the time. My environment is on Windows server 2012, being ran with VMware. I have tried local admin accounts as well as domain admin accounts. Thank you for any advice and/or help.

最满意答案

你不是缺少AGTSVCACCOUNT和AGTSVCPASSWORD变量吗？ 您的示例仅指定数据库引擎服务的凭据，而不是代理服务。

Aren't you missing AGTSVCACCOUNT and AGTSVCPASSWORD variables? Your example only specifies the credentials for the database engine service, not the agent service.