使用命令行提示符安装SQL Server 2008 R2无法使其正确 [英] Installing SQL Server 2008 R2 by using command line prompt, cannot make it correct

问题描述

我一直在尝试编写用于安装SQL Sever 2008 R2 Express版本4天的正确命令行，并且我已阅读本网站以及其他网站上的所有相关帖子。我还在MSDN上阅读了如何：从命令提示符安装SQL Server 2008 R2。但它们都不起作用。



现在这里是我的论点（不包括setup.exe）。

 / qs / ACTION = Install / FEATURES = SQL / INSTANCENAME = MSSQLSERVER / ADDCURRENTUSERASSQLADIN = True / IACCEPTSQLSERVERLICENSETERMS 

问题：通过使用它，SQL安装程序可以显示并继续，直到安装过程并关闭而不会出现任何错误。



我已经使用了我的所有想法找出我命令行中的错误。



请帮我为SQL Server 2008 R2安装编写正确的命令行。



谢谢!!!

解决方案

SQL Server 2008无人值守安装 [ ^ ]



坦率地说，我从未在我的应用安装程序中包含SQL Server安装。用户已经在运行SQL Server安装。他们只需提供服务器名称，用户名和密码即可获得。

我终于做对了。



这是我使用的命令行，它可以工作。

 / qs / ACTION =安装/ FEATURES = SQLEngine，SSMS / INSTANCENAME =  此处的实例名称 / SQLSVCACCOUNT =   NT AUTHORITY \Network Service / SQLSYSADMINACCOUNTS =  管理员 / AGTSVCACCOUNT =   NT AUTHORITY \Network Service / IACCEPTSQLSERVERLICENSETERMS 
 

您还可以更改其他帐户，但您要使用的帐户必须具有已在您的系统中创建，它是一个更好的管理员帐户，您不需要指定密码。

I have been trying to write the right command line for installing SQL Sever 2008 R2 Express version 4 days and I have read all related posts on this website as well as other website. I also have read the "How to: Install SQL Server 2008 R2 from the Command Prompt" on MSDN. But none of them works.

Now here is my arguments(exclude setup.exe).

/qs /ACTION=Install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /ADDCURRENTUSERASSQLADMIN=True /IACCEPTSQLSERVERLICENSETERMS

Problem :By using it, the SQL installer can show up and proceed until the Installation Process and closes without any errors popping up.

I have used all my ideas to find out what''s wrong in my command line.

Please help me to write the right command line for SQL Server 2008 R2 installation.

Thank you!!!

解决方案

"SQL Server 2008 Unattended Install"[^]

Frankly, I never include a SQL Server install in my app installers. It''s up to the user to have a SQL Server installation already running. They just need to supply the server name, username and password to get at it.

I finally got it right.

Here is the command line I use and it works.

/qs /ACTION=Install /FEATURES=SQLEngine,SSMS /INSTANCENAME="Your instance name here" /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSYSADMINACCOUNTS="Administrators" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS

You can also change other accounts, but the accounts you are going to use must have been created in your system and it is better an admin account and you do not need to specify the password.

这篇关于使用命令行提示符安装SQL Server 2008 R2无法使其正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！