Shulou(Shulou.com)06/03 Report--

Note:

Selection of installation components

Users corresponding to component services

Installation sorting, such as default sorting, later modification methods

1. Create a new SQLADMIN

Create a new user sqladmin in AD and add it to the domain admin group

2. SQL installation

Collation: SQL_Latin1_General_CP1_CI_AS needs to be adjusted to the database engine

3. SQL sorting adjustment method

If you choose the default installation, the error will be reported when installing SCCM later as follows

Sort by default installation

The modification method is as follows:

C:\ Users\ administrator.CORP > cd\

C:\ > cd C:\ Program Files\ Microsoft SQLServer\ 110\ Setup Bootstrap\ SQLServer2012

C:\ Program Files\ Microsoft SQLServer\ 110\ Setup Bootstrap\ SQLServer2012 > net stop

Mssqlserver

The SQL Server (MSSQLSERVER) service is stopping..

The SQL Server (MSSQLSERVER) service stopped successfully.

C:\ Program Files\ Microsoft SQLServer\ 110\ Setup Bootstrap\ SQLServer2012 > Setup / Q

UIET / ACTION=REBUILDDATABASE / instancename=MSSQLSERVER / SQLSYSADMINACCOUNTS=corp

\ administrator / sapwd=Wh@88252581 / sqlcollation=Chinese_PRC_CS_AS

C:\ Program Files\ Microsoft SQLServer\ 110\ Setup Bootstrap\ SQLServer2012 >

C:\ Program Files\ Microsoft SQLServer\ 110\ Setup Bootstrap\ SQLServer2012 > Net star

T mssqlserver

The SQL Server (MSSQLSERVER) service is starting.

The SQL Server (MSSQLSERVER) service has started successfully.

C:\ Program Files\ Microsoft SQLServer\ 110\ Setup Bootstrap\ SQLServer2012 > net stop

Mssqlserver

The SQL Server (MSSQLSERVER) service is stopping.

The SQL Server (MSSQLSERVER) service stopped successfully.

C:\ Program Files\ Microsoft SQLServer\ 110\ Setup Bootstrap\ SQLServer2012 > Setup / Q

UIET / ACTION=REBUILDDATABASE / instancename=MSSQLSERVER / SQLSYSADMINACCOUNTS=corp

\ administrator / sapwd=Wh@88252581 / sqlcollation=SQL_Latin1_General_CP1_CI_AS

C:\ Program Files\ Microsoft SQLServer\ 110\ Setup Bootstrap\ SQLServer2012 > Net star

T mssqlserver

The SQL Server (MSSQLSERVER) service is starting.

The SQL Server (MSSQLSERVER) service has started successfully.

C:\ Program Files\ Microsoft SQLServer\ 110\ Setup Bootstrap\ SQLServer2012 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.