我正在尝试通过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: 0The following is the simple line for executing the install.
&'D:\FilePath\setup.exe' /QS /ConfigurationFile=C:\FilePath\ConfigurationFile.iniIn 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.
更多推荐
发布评论