SLTechnology News&Howtos › Servers ›

SCCM deployment (3)-SQL installation

Shulou Source: shulou.com Published: 2022-06-03 08:43:30 11月08日 Update

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.