结果发现自己一些不兢兢业业/错误的地方把温馨也给坑了,结果发现自己一些不谨慎/错误的地点把自己也给坑了

前几日遇见一个案例,在选用命令修改一个测试服务器(SQL Server
2014标准版)的服务器排序规则时,遭受了上面错误消息

前几天遇见一个案例,在运用命令修改一个测试服务器(SQL Server
2014标准版)的服务器排序规则时,境遇了下面错误音信

在我们设置System Center中的组件时,需要SQL
Server数据库。比如设置SCCM2012时,在装置SQL Server
2012的长河中需要排序规则选拔“SQL_Latin1_General_CP1_CI_AS”,但反复在设置的时候忘记了改动选项,默认实例的服务器排序规则是:“Chinese_PRC_CI_AS”,大家什么样修改成“SQL_Latin1_General_CP1_CI_AS”呢?步骤如下:

(具体账号音讯脱敏处理,随机生成一个账号密码)

(具体账号新闻脱敏处理,随机生成一个账号密码)

在指令窗口中操作以下步骤:

The
Windows account sa does not exist and cannot be provisioned as a SQL
Server system administrator

The
Windows account sa does not exist and cannot be provisioned as a SQL
Server system administrator

率先步:进入SQL Server 安装文件所在目录setup.exe文件所在目录)

 

 

第二步:截至SQL Server服务—运行命令:Net stop mssqlserver

图片 1

图片 2

第三步:Setup /QUIET /ACTION=REBUILDDATABASE /instancename=MSSQLSERVER

 

 

/SQLSYSADMINACCOUNTS=administrator
/[email protected]#
/sqlcollation=Chinese_PRC_CI_AS

c:\SQLServer_12.0_Full>Setup
/QUIET /ACTION=REBUILDDATABASE 
/INSTANCENAME=MSSQL

c:\SQLServer_12.0_Full>Setup
/QUIET /ACTION=REBUILDDATABASE 
/INSTANCENAME=MSSQL

第四步:启动SQL Server服务—运行命令:Net start mssqlserver

SERVER
/SQLSYSADMINACCOUNTS=sa  
/SAPWD=Sa!y#456 
/SQLCOLLATION=Chinese_PRC_CI_AS

SERVER
/SQLSYSADMINACCOUNTS=sa  
/SAPWD=Sa!y#456 
/SQLCOLLATION=Chinese_PRC_CI_AS

指令格式是:Setup /QUIET /ACTION=REBUILDDATABASE
/INSTANCENAME=InstanceName

 

 

/SQLSYSADMINACCOUNTS=accounts /SAPWD= StrongPassword
/SQLCOLLATION=CollationName

Microsoft
(R) SQL Server 2014 12.00.5000.00

Microsoft
(R) SQL Server 2014 12.00.5000.00

注:InstanceName
是实例名称,accounts是administrator账号,sapwd是sa的密码(需要复杂度)

Copyright
(c) Microsoft Corporation.  All rights
reserved.

Copyright
(c) Microsoft Corporation.  All rights
reserved.

本文出自 “微软技术专题”
博客,请务必保留此出处http://nickzp.blog.51cto.com/12728/1304717

 

 

http://www.bkjia.com/windows/613409.htmlwww.bkjia.comtruehttp://www.bkjia.com/windows/613409.htmlTechArticle在我们安装System Center中的组件时,需要SQL
Server数据库。比如设置SCCM2012时,在设置SQL Server
2012的进程中需要排序规则选取“SQL_Latin1_Genera…

The
following error occurred:

The
following error occurred:

The
Windows account sa does not exist and cannot be provisioned as a SQL
Server

The
Windows account sa does not exist and cannot be provisioned as a SQL
Server

system
administrator.

system
administrator.

 

 

Error
result: -2061893626

Error
result: -2061893626

Result
facility code: 1306

Result
facility code: 1306

Result
error code: 6

Result
error code: 6

 

 

Please
review the summary.txt log for further details

Please
review the summary.txt log for further details

 

 

 

 

末端折腾了很久后,发现这种写法居然是荒谬的,由于投机在出手此前参考了自己原先写的MS
SQL
排序规则总计
这篇博文,结果发现自己一些不兢兢业业/错误的地点把温馨也给坑了。希望不用把别人也坑了!!!时间太久远了,怎么也想不起当初怎么栽培了如此一个荒唐,
不问可知,这篇博文里面确实有一个谬误的地方。希望今后要借鉴!

末端折腾了很久后,发现这种写法居然是不当的,由于投机在出手在此以前参考了协调原先写的MS
SQL
排序规则总括
这篇博文,结果发现自己一些不审慎/错误的地方把团结也给坑了。希望不用把别人也坑了!!!时间太久远了,怎么也想不起当初怎么栽培了如此一个错误,
总而言之,这篇博文里面确实有一个不当的地方。希望将来要借鉴!

 

 

没错的写法为/SQLSYSADMINACCOUNTS参数后指定域账号或本机NT账号,这多少个可以通过查看援助新闻

毋庸置疑的写法为/SQLSYSADMINACCOUNTS参数后指定域账号或本机NT账号,这多少个可以经过翻看援助音信

 

 

 

 

c:\SQLServer_12.0_Full>Setup
/QUIET /ACTION=REBUILDDATABASE 
/INSTANCENAME=MSSQLSERVER

c:\SQLServer_12.0_Full>Setup
/QUIET /ACTION=REBUILDDATABASE 
/INSTANCENAME=MSSQLSERVER

 /SQLSYSADMINACCOUNTS=azrnt18\azrnt18   
/SAPWD=”Sa!y#456″ /SQLCOLLATION=Chinese_PRC_CI_AS

 /SQLSYSADMINACCOUNTS=azrnt18\azrnt18   
/SAPWD=”Sa!y#456″ /SQLCOLLATION=Chinese_PRC_CI_AS

Microsoft
(R) SQL Server 2014 12.00.5000.00

Microsoft
(R) SQL Server 2014 12.00.5000.00

Copyright
(c) Microsoft Corporation.  All rights
reserved.

Copyright
(c) Microsoft Corporation.  All rights
reserved.

 

 

 

 

图片 3

图片 4

 

 

 

 

setup
/? 或setup 
/help查看参数音讯,SQLSYSADMINACCOUNTS的介绍、解释如下所示:

setup
/? 或setup 
/help查看参数音信,SQLSYSADMINACCOUNTS的牵线、解释如下所示:

 

 

SQLSYSADMINACCOUNTS    Windows
account(s) to provision as SQL Server system administrators.

SQLSYSADMINACCOUNTS    Windows
account(s) to provision as SQL Server system administrators.

 

 

 

 

也就是说SQLSYSADMINACCOUNTS参数后指定的是有SQL
Server管理员权限的Windows账号,由于最下面最下面点名参数的值为sa,所以才会直接报这多少个错误。

也就是说SQLSYSADMINACCOUNTS参数后指定的是有SQL
Server管理员权限的Windows账号,由于最下面最下边点名参数的值为sa,所以才会直接报这么些荒唐。

 

 

c:\SQLServer_12.0_Full>setup /help

Microsoft (R) SQL Server 2014 12.00.5000.00

Copyright (c) Microsoft Corporation.  All rights reserved.

 

Usage:

 setup.exe /[option]={value} /[option]={value} ...

 

 Options:

 ACTION                       Specifies a Setup work flow, like INSTALL,

                              UNINSTALL, or UPGRADE. This is a required

                              parameter.

 ADDCURRENTUSERASSQLADMIN     Provision current user as a Database Engine

                              system administrator for %SQL_PRODUCT_SHORT_NAME%

                              Express.

 AGTDOMAINGROUP               Either domain user name or system account

 AGTSVCACCOUNT                Either domain user name or system account

 AGTSVCPASSWORD               Password for domain user name. Not required for

                              system account

 AGTSVCSTARTUPTYPE            Startup type for the SQL Server Agent service.

                              Supported values are Manual, Automatic or

                              Disabled.

 ALLINSTANCES                 Specifies that all instances are to be included

                              in the Setup operation. This parameter is

                              supported only when applying a patch.

 ALLOWUPGRADEFORSSRSSHAREPOIN

                              RSInputSettings_AllowUpgradeForSSRSSharePointMode_

Description

 ASBACKUPDIR                  The location for the Analysis Services backup

                              files.

 ASCOLLATION                  The collation used by Analysis Services.

 ASCONFIGDIR                  The location for the Analysis Services

                              configuration files.

 ASDATADIR                    The location for the Analysis Services data

                              files.

 ASLOGDIR                     The location for the Analysis Services log files.

 ASPROVIDERMSOLAP             Specifies if the MSOLAP provider can run in

                              process.

 ASSERVERMODE                 Specifies the server mode of the Analysis

                              Services instance. Valid values are

                              MULTIDIMENSIONAL and TABULAR. The default value

                              is MULTIDIMENSIONAL.

 ASSVCACCOUNT                 The account used by the Analysis Services

                              service.

 ASSVCPASSWORD                The password for the Analysis Services service

                              account.

 ASSVCSTARTUPTYPE             Controls the service startup type setting for the

                              service.

 ASSYSADMINACCOUNTS           Specifies the list of administrator accounts to

                              provision.

 ASTEMPDIR                    The location for the Analysis Services temporary

                              files.

 BROWSERSVCSTARTUPTYPE        Startup type for Browser Service.

 CLTCTLRNAME                  The computer name that the client communicates

                              with for the Distributed Replay Controller

                              service.

 CLTRESULTDIR                 The result directory for the Distributed Replay

                              Client service.

 CLTSTARTUPTYPE               The startup type for the Distributed Replay

                              Client service.

 CLTSVCACCOUNT                The account used by the Distributed Replay Client

                              service.

 CLTSVCPASSWORD               The password for the Distributed Replay Client

                              service account.

 CLTWORKINGDIR                The working directory for the Distributed Replay

                              Client service.

 CLUSTERPASSIVE               Specifies that SQL Server Setup should not manage

                              the SQL Server services. This option should be

                              used only in a non-Microsoft cluster environment.

 COMMFABRICENCRYPTION         MATRIXCOMMMESSAGEPROTECTION {0,1}

 COMMFABRICNETWORKLEVEL       MATRIXCOMMNETWORKISOLATION {0,1}

 COMMFABRICPORT               MATRIXCOMMPORT <port>

 CONFIGURATIONFILE            Specifies the configuration file to be used for

                              Setup.

 CONFIRMIPDEPENDENCYCHANGE    Indicates that the change in IP address resource

                              dependency type for the SQL Server multi-subnet

                              failover cluster is accepted.

 CTLRSTARTUPTYPE              The startup type for the Distributed Replay

                              Controller service.

 CTLRSVCACCOUNT               The account used by the Distributed Replay

                              Controller service.

 CTLRSVCPASSWORD              The password for the Distributed Replay

                              Controller service account.

 CTLRUSERS                    The Windows account(s) used to grant permission

                              to the Distributed Replay Controller service.

 ENABLERANU                   Set to "1" to enable RANU for SQL Server Express.

 ENU                          Use the /ENU parameter to install the English

                              version of SQL Server on your localized Windows

                              operating system.

 ERRORREPORTING               Specify if errors can be reported to Microsoft to

                              improve future SQL Server releases. Specify 1 or

                              True to enable and 0 or False to disable this

                              feature.

 FAILOVERCLUSTERDISKS         Specifies a cluster shared disk to associate with

                              the SQL Server failover cluster instance.

 FAILOVERCLUSTERGROUP         Specifies the name of the cluster group for the

                              SQL Server failover cluster instance.

 FAILOVERCLUSTERIPADDRESSES   Specifies an encoded IP address. The encodings

                              are semicolon-delimited (;), and follow the

                              format <IP Type>;<address>;<network name>;<subnet

                              mask>. Supported IP types include DHCP, IPV4, and

                              IPV6.

 FAILOVERCLUSTERNETWORKNAME   Specifies the name of the SQ LServer failover

                              cluster instance.  This name is the network name

                              that is used to connect to SQL Server services.

 FAILOVERCLUSTERROLLOWNERSHIP Specifies whether the upgraded nodes should take

                              ownership of the failover instance group or not.

                              Use 0 to retain ownership in the legacy nodes, 1

                              to make the upgraded nodes take ownership, or 2

                              to let SQL Server Setup decide when to move

                              ownership.

 FEATURES                     Specifies features to install, uninstall, or

                              upgrade. The list of top-level features include

                              SQL, AS, RS, IS, MDS, and Tools. The SQL feature

                              will install the Database Engine, Replication,

                              Full-Text, and Data Quality Services (DQS)

                              server. The Tools feature will install Management

                              Tools, Books online components, SQL Server Data

                              Tools, and other shared components.

 FILESTREAMLEVEL              Level to enable FILESTREAM feature at (0, 1, 2 or

                              3).

 FILESTREAMSHARENAME          Name of Windows share to be created for

                              FILESTREAM File I/O.

 FTSVCACCOUNT                 User account for Full-text Filter Daemon Host.

 FTSVCPASSWORD                User password for Full-text Filter Daemon Host

                              account.

 FTUPGRADEOPTION              Full-text catalog upgrade option.

 HELP                         Displays the command line parameters usage

 IACCEPTSQLSERVERLICENSETERMS By specifying this parameter and accepting the

                              SQL Server license terms, you acknowledge that

                              you have read and understood the terms of use.

 INDICATEPROGRESS             Specifies that the detailed Setup log should be

                              piped to the console.

 INSTALLSHAREDDIR             Specify the root installation directory for

                              shared components.  This directory remains

                              unchanged after shared components are already

                              installed.

 INSTALLSHAREDWOWDIR          Specify the root installation directory for the

                              WOW64 shared components.  This directory remains

                              unchanged after WOW64 shared components are

                              already installed.

 INSTALLSQLDATADIR            The Database Engine root data directory.

 INSTANCEDIR                  Specify the instance root directory.

 INSTANCEID                   Specify the Instance ID for the SQL Server

                              features you have specified. SQL Server directory

                              structure, registry structure, and service names

                              will incorporate the instance ID of the SQL

                              Server instance.

 INSTANCENAME                 Specify a default or named instance. MSSQLSERVER

                              is the default instance for non-Express editions

                              and SQLExpress for Express editions. This

                              parameter is required when installing the SQL

                              Server Database Engine (SQL), Analysis Services

                              (AS), or Reporting Services (RS).

 ISSVCACCOUNT                 Either domain user name or system account.

 ISSVCPASSWORD                Password for domain user.

 ISSVCSTARTUPTYPE             Automatic, Manual or Disabled.

 MATRIXCMBRICKCOMMPORT        MATRIXCMBRICKCOMMPORT portNumber

 MATRIXCMSERVERNAME           MATRIXCMSERVERNAME hostName\instanceName

 MATRIXNAME                   MATRIXNAME=<name>

 NPENABLED                    Specify 0 to disable or 1 to enable the Named

                              Pipes protocol.

 PID                          Specify the SQL Server product key to configure

                              which edition you would like to use.

 QUIET                        Setup will not display any user interface.

 QUIETSIMPLE                  Setup will display progress only, without any

                              user interaction.

 ROLE                         Detailed help for command line argument ROLE has

                              not been defined yet.

 RSCATALOGSERVERINSTANCENAME  The SQL Server server for the report server

                              catalog database.

 RSINSTALLMODE                RSInputSettings_RSInstallMode_Description

 RSSHPINSTALLMODE             RSInputSettings_RSInstallMode_Description

 RSSVCACCOUNT                 Specify the service account of the report server.

                              This value is required. If you omit this value,

                              Setup will use the default built-in account for

                              the current operating system (either

                              NetworkService or LocalSystem). If you specify a

                              domain user account, the domain must be under 254

                              characters and the user name must be under 20

                              characters. The account name cannot contain the

                              following characters:

                              " / \ [ ] : ; | = , + * ? < >

 RSSVCPASSWORD                Specify a strong password for the account. A

                              strong password is at least 8 characters and

                              includes a combination of upper and lower case

                              alphanumeric characters and at least one symbol

                              character. Avoid spelling an actual word or name

                              that might be listed in a dictionary.

 RSSVCSTARTUPTYPE             Specifies the startup mode for the Report Server

                              service. Valid values include Manual, Automatic,

                              and Disabled. The default value for StartupType

                              is Manual, where the server is started when a

                              request is received.

 RSUPGRADEDATABASEACCOUNT     RSInputSettings_RSInstallMode_Description

 RSUPGRADEPASSWORD            RSInputSettings_RSInstallMode_Description

 RULES                        Specifies the list of rule IDs or rule group IDs

                              to run.

 SAPWD                        Password for SQL Server sa account.

 SECURITYMODE                 The default is Windows Authentication. Use "SQL"

                              for Mixed Mode Authentication.

 SQLBACKUPDIR                 Default directory for the Database Engine backup

                              files.

 SQLCOLLATION                 Specifies a Windows collation or an SQL collation

                              to use for the Database Engine.

 SQLSVCACCOUNT                Account for SQL Server service: Domain\User or

                              system account.

 SQLSVCPASSWORD               A SQL Server service password is required only

                              for a domain account.

 SQLSVCSTARTUPTYPE            Startup type for the SQL Server service.

 SQLSYSADMINACCOUNTS          Windows account(s) to provision as SQL Server

                              system administrators.

 SQLTEMPDBDIR                 Directory for Database Engine TempDB files.

 SQLTEMPDBLOGDIR              Directory for the Database Engine TempDB log

                              files.

 SQLUSERDBDIR                 Default directory for the Database Engine user

                              databases.

 SQLUSERDBLOGDIR              Default directory for the Database Engine user

                              database logs.

 SQMREPORTING                 Specify that SQL Server feature usage data can be

                              collected and sent to Microsoft. Specify 1 or

                              True to enable and 0 or False to disable this

                              feature.

 TCPENABLED                   Specify 0 to disable or 1 to enable the TCP/IP

                              protocol.

 UIMODE                       Parameter that controls the user interface

                              behavior. Valid values are Normal for the full

                              UI,AutoAdvance for a simplied UI, and

                              EnableUIOnServerCore for bypassing Server Core

                              setup GUI block.

 UpdateEnabled                Specify whether SQL Server Setup should discover

                              and include product updates. The valid values are

                              True and False or 1 and 0. By default SQL Server

                              Setup will include updates that are found.

 UpdateSource                 Specify the location where SQL Server Setup will

                              obtain product updates. The valid values are "MU"

                              to search Microsoft Update, a valid folder path,

                              a relative path such as .\MyUpdates or a UNC

                              share. By default SQL Server Setup will search

                              Microsoft Update or a Windows Update service

                              through the Window Server Update Services.

 USEMICROSOFTUPDATE           If this parameter is provided, then this computer

                              will use Microsoft Update to check for updates.

 X86                          Specifies that Setup should install into WOW64.

                              This command line argument is not supported on an

                              IA64 or a 32-bit system.

 

Full unattended installation example, showing all required parameters:

 

 

setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /PID=<validpid> /FEAT

URES=SQL,AS,RS,IS,Tools

/INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="MyDomain\MyAccount"

/SQLSVCPASSWORD="************" /SQLSYSADMINACCOUNTS="MyDomain\MyAccount "

/AGTSVCACCOUNT="MyDomain\MyAccount" /AGTSVCPASSWORD="************"

/ASSVCACCOUNT="MyDomain\MyAccount" /ASSVCPASSWORD="************"

/RSSVCACCOUNT="MyDomain\MyAccount" /RSSVCPASSWORD="************"

/ISSVCAccount="MyDomain\MyAccount" /ISSVCPASSWORD="************"

/ASSYSADMINACCOUNTS="MyDomain\MyAccount"

 

Press any key to exit...
c:\SQLServer_12.0_Full>setup /help

Microsoft (R) SQL Server 2014 12.00.5000.00

Copyright (c) Microsoft Corporation.  All rights reserved.

 

Usage:

 setup.exe /[option]={value} /[option]={value} ...

 

 Options:

 ACTION                       Specifies a Setup work flow, like INSTALL,

                              UNINSTALL, or UPGRADE. This is a required

                              parameter.

 ADDCURRENTUSERASSQLADMIN     Provision current user as a Database Engine

                              system administrator for %SQL_PRODUCT_SHORT_NAME%

                              Express.

 AGTDOMAINGROUP               Either domain user name or system account

 AGTSVCACCOUNT                Either domain user name or system account

 AGTSVCPASSWORD               Password for domain user name. Not required for

                              system account

 AGTSVCSTARTUPTYPE            Startup type for the SQL Server Agent service.

                              Supported values are Manual, Automatic or

                              Disabled.

 ALLINSTANCES                 Specifies that all instances are to be included

                              in the Setup operation. This parameter is

                              supported only when applying a patch.

 ALLOWUPGRADEFORSSRSSHAREPOIN

                              RSInputSettings_AllowUpgradeForSSRSSharePointMode_

Description

 ASBACKUPDIR                  The location for the Analysis Services backup

                              files.

 ASCOLLATION                  The collation used by Analysis Services.

 ASCONFIGDIR                  The location for the Analysis Services

                              configuration files.

 ASDATADIR                    The location for the Analysis Services data

                              files.

 ASLOGDIR                     The location for the Analysis Services log files.

 ASPROVIDERMSOLAP             Specifies if the MSOLAP provider can run in

                              process.

 ASSERVERMODE                 Specifies the server mode of the Analysis

                              Services instance. Valid values are

                              MULTIDIMENSIONAL and TABULAR. The default value

                              is MULTIDIMENSIONAL.

 ASSVCACCOUNT                 The account used by the Analysis Services

                              service.

 ASSVCPASSWORD                The password for the Analysis Services service

                              account.

 ASSVCSTARTUPTYPE             Controls the service startup type setting for the

                              service.

 ASSYSADMINACCOUNTS           Specifies the list of administrator accounts to

                              provision.

 ASTEMPDIR                    The location for the Analysis Services temporary

                              files.

 BROWSERSVCSTARTUPTYPE        Startup type for Browser Service.

 CLTCTLRNAME                  The computer name that the client communicates

                              with for the Distributed Replay Controller

                              service.

 CLTRESULTDIR                 The result directory for the Distributed Replay

                              Client service.

 CLTSTARTUPTYPE               The startup type for the Distributed Replay

                              Client service.

 CLTSVCACCOUNT                The account used by the Distributed Replay Client

                              service.

 CLTSVCPASSWORD               The password for the Distributed Replay Client

                              service account.

 CLTWORKINGDIR                The working directory for the Distributed Replay

                              Client service.

 CLUSTERPASSIVE               Specifies that SQL Server Setup should not manage

                              the SQL Server services. This option should be

                              used only in a non-Microsoft cluster environment.

 COMMFABRICENCRYPTION         MATRIXCOMMMESSAGEPROTECTION {0,1}

 COMMFABRICNETWORKLEVEL       MATRIXCOMMNETWORKISOLATION {0,1}

 COMMFABRICPORT               MATRIXCOMMPORT <port>

 CONFIGURATIONFILE            Specifies the configuration file to be used for

                              Setup.

 CONFIRMIPDEPENDENCYCHANGE    Indicates that the change in IP address resource

                              dependency type for the SQL Server multi-subnet

                              failover cluster is accepted.

 CTLRSTARTUPTYPE              The startup type for the Distributed Replay

                              Controller service.

 CTLRSVCACCOUNT               The account used by the Distributed Replay

                              Controller service.

 CTLRSVCPASSWORD              The password for the Distributed Replay

                              Controller service account.

 CTLRUSERS                    The Windows account(s) used to grant permission

                              to the Distributed Replay Controller service.

 ENABLERANU                   Set to "1" to enable RANU for SQL Server Express.

 ENU                          Use the /ENU parameter to install the English

                              version of SQL Server on your localized Windows

                              operating system.

 ERRORREPORTING               Specify if errors can be reported to Microsoft to

                              improve future SQL Server releases. Specify 1 or

                              True to enable and 0 or False to disable this

                              feature.

 FAILOVERCLUSTERDISKS         Specifies a cluster shared disk to associate with

                              the SQL Server failover cluster instance.

 FAILOVERCLUSTERGROUP         Specifies the name of the cluster group for the

                              SQL Server failover cluster instance.

 FAILOVERCLUSTERIPADDRESSES   Specifies an encoded IP address. The encodings

                              are semicolon-delimited (;), and follow the

                              format <IP Type>;<address>;<network name>;<subnet

                              mask>. Supported IP types include DHCP, IPV4, and

                              IPV6.

 FAILOVERCLUSTERNETWORKNAME   Specifies the name of the SQ LServer failover

                              cluster instance.  This name is the network name

                              that is used to connect to SQL Server services.

 FAILOVERCLUSTERROLLOWNERSHIP Specifies whether the upgraded nodes should take

                              ownership of the failover instance group or not.

                              Use 0 to retain ownership in the legacy nodes, 1

                              to make the upgraded nodes take ownership, or 2

                              to let SQL Server Setup decide when to move

                              ownership.

 FEATURES                     Specifies features to install, uninstall, or

                              upgrade. The list of top-level features include

                              SQL, AS, RS, IS, MDS, and Tools. The SQL feature

                              will install the Database Engine, Replication,

                              Full-Text, and Data Quality Services (DQS)

                              server. The Tools feature will install Management

                              Tools, Books online components, SQL Server Data

                              Tools, and other shared components.

 FILESTREAMLEVEL              Level to enable FILESTREAM feature at (0, 1, 2 or

                              3).

 FILESTREAMSHARENAME          Name of Windows share to be created for

                              FILESTREAM File I/O.

 FTSVCACCOUNT                 User account for Full-text Filter Daemon Host.

 FTSVCPASSWORD                User password for Full-text Filter Daemon Host

                              account.

 FTUPGRADEOPTION              Full-text catalog upgrade option.

 HELP                         Displays the command line parameters usage

 IACCEPTSQLSERVERLICENSETERMS By specifying this parameter and accepting the

                              SQL Server license terms, you acknowledge that

                              you have read and understood the terms of use.

 INDICATEPROGRESS             Specifies that the detailed Setup log should be

                              piped to the console.

 INSTALLSHAREDDIR             Specify the root installation directory for

                              shared components.  This directory remains

                              unchanged after shared components are already

                              installed.

 INSTALLSHAREDWOWDIR          Specify the root installation directory for the

                              WOW64 shared components.  This directory remains

                              unchanged after WOW64 shared components are

                              already installed.

 INSTALLSQLDATADIR            The Database Engine root data directory.

 INSTANCEDIR                  Specify the instance root directory.

 INSTANCEID                   Specify the Instance ID for the SQL Server

                              features you have specified. SQL Server directory

                              structure, registry structure, and service names

                              will incorporate the instance ID of the SQL

                              Server instance.

 INSTANCENAME                 Specify a default or named instance. MSSQLSERVER

                              is the default instance for non-Express editions

                              and SQLExpress for Express editions. This

                              parameter is required when installing the SQL

                              Server Database Engine (SQL), Analysis Services

                              (AS), or Reporting Services (RS).

 ISSVCACCOUNT                 Either domain user name or system account.

 ISSVCPASSWORD                Password for domain user.

 ISSVCSTARTUPTYPE             Automatic, Manual or Disabled.

 MATRIXCMBRICKCOMMPORT        MATRIXCMBRICKCOMMPORT portNumber

 MATRIXCMSERVERNAME           MATRIXCMSERVERNAME hostName\instanceName

 MATRIXNAME                   MATRIXNAME=<name>

 NPENABLED                    Specify 0 to disable or 1 to enable the Named

                              Pipes protocol.

 PID                          Specify the SQL Server product key to configure

                              which edition you would like to use.

 QUIET                        Setup will not display any user interface.

 QUIETSIMPLE                  Setup will display progress only, without any

                              user interaction.

 ROLE                         Detailed help for command line argument ROLE has

                              not been defined yet.

 RSCATALOGSERVERINSTANCENAME  The SQL Server server for the report server

                              catalog database.

 RSINSTALLMODE                RSInputSettings_RSInstallMode_Description

 RSSHPINSTALLMODE             RSInputSettings_RSInstallMode_Description

 RSSVCACCOUNT                 Specify the service account of the report server.

                              This value is required. If you omit this value,

                              Setup will use the default built-in account for

                              the current operating system (either

                              NetworkService or LocalSystem). If you specify a

                              domain user account, the domain must be under 254

                              characters and the user name must be under 20

                              characters. The account name cannot contain the

                              following characters:

                              " / \ [ ] : ; | = , + * ? < >

 RSSVCPASSWORD                Specify a strong password for the account. A

                              strong password is at least 8 characters and

                              includes a combination of upper and lower case

                              alphanumeric characters and at least one symbol

                              character. Avoid spelling an actual word or name

                              that might be listed in a dictionary.

 RSSVCSTARTUPTYPE             Specifies the startup mode for the Report Server

                              service. Valid values include Manual, Automatic,

                              and Disabled. The default value for StartupType

                              is Manual, where the server is started when a

                              request is received.

 RSUPGRADEDATABASEACCOUNT     RSInputSettings_RSInstallMode_Description

 RSUPGRADEPASSWORD            RSInputSettings_RSInstallMode_Description

 RULES                        Specifies the list of rule IDs or rule group IDs

                              to run.

 SAPWD                        Password for SQL Server sa account.

 SECURITYMODE                 The default is Windows Authentication. Use "SQL"

                              for Mixed Mode Authentication.

 SQLBACKUPDIR                 Default directory for the Database Engine backup

                              files.

 SQLCOLLATION                 Specifies a Windows collation or an SQL collation

                              to use for the Database Engine.

 SQLSVCACCOUNT                Account for SQL Server service: Domain\User or

                              system account.

 SQLSVCPASSWORD               A SQL Server service password is required only

                              for a domain account.

 SQLSVCSTARTUPTYPE            Startup type for the SQL Server service.

 SQLSYSADMINACCOUNTS          Windows account(s) to provision as SQL Server

                              system administrators.

 SQLTEMPDBDIR                 Directory for Database Engine TempDB files.

 SQLTEMPDBLOGDIR              Directory for the Database Engine TempDB log

                              files.

 SQLUSERDBDIR                 Default directory for the Database Engine user

                              databases.

 SQLUSERDBLOGDIR              Default directory for the Database Engine user

                              database logs.

 SQMREPORTING                 Specify that SQL Server feature usage data can be

                              collected and sent to Microsoft. Specify 1 or

                              True to enable and 0 or False to disable this

                              feature.

 TCPENABLED                   Specify 0 to disable or 1 to enable the TCP/IP

                              protocol.

 UIMODE                       Parameter that controls the user interface

                              behavior. Valid values are Normal for the full

                              UI,AutoAdvance for a simplied UI, and

                              EnableUIOnServerCore for bypassing Server Core

                              setup GUI block.

 UpdateEnabled                Specify whether SQL Server Setup should discover

                              and include product updates. The valid values are

                              True and False or 1 and 0. By default SQL Server

                              Setup will include updates that are found.

 UpdateSource                 Specify the location where SQL Server Setup will

                              obtain product updates. The valid values are "MU"

                              to search Microsoft Update, a valid folder path,

                              a relative path such as .\MyUpdates or a UNC

                              share. By default SQL Server Setup will search

                              Microsoft Update or a Windows Update service

                              through the Window Server Update Services.

 USEMICROSOFTUPDATE           If this parameter is provided, then this computer

                              will use Microsoft Update to check for updates.

 X86                          Specifies that Setup should install into WOW64.

                              This command line argument is not supported on an

                              IA64 or a 32-bit system.

 

Full unattended installation example, showing all required parameters:

 

 

setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /PID=<validpid> /FEAT

URES=SQL,AS,RS,IS,Tools

/INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="MyDomain\MyAccount"

/SQLSVCPASSWORD="************" /SQLSYSADMINACCOUNTS="MyDomain\MyAccount "

/AGTSVCACCOUNT="MyDomain\MyAccount" /AGTSVCPASSWORD="************"

/ASSVCACCOUNT="MyDomain\MyAccount" /ASSVCPASSWORD="************"

/RSSVCACCOUNT="MyDomain\MyAccount" /RSSVCPASSWORD="************"

/ISSVCAccount="MyDomain\MyAccount" /ISSVCPASSWORD="************"

/ASSYSADMINACCOUNTS="MyDomain\MyAccount"

 

Press any key to exit...

相关文章