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

In this issue, Xiaobian will bring you about how to deploy SQL database in SCCM 2012R. The article is rich in content and analyzed and described from a professional perspective. After reading this article, I hope you can gain something.

Before deploying SCCM, you first need to deploy a SQL database

The first step is to prepare the normal operating system.

Turn off IPv6 in NIC Properties

Turn off firewall, account access control, IE enhanced security settings

Install. Net Framework 3.5.1

Then, place the SQL Server 2014 Enterprise With SP2 x64 CD into the server and perform a fresh standalone installation

Select all features with default values

Select the SQL functionality you want (only Database Engine Services functionality is required for each site server.)

Installation path remains default

Confirm function rule verification passes

instance name remains default

Service accounts section Modify SQL Server Database Engine services to local system accounts

Focus!!:

Collation changed to SQL_Latin1_General_CP1_CI_AS

Ensure that the server is configured for Windows authentication and add the required SQL administrators

installation is complete

Verify in SQL Configuration Manager that the database service status and TCP port is 1433 instead of empty

Open SQL management tools and modify server properties-> Memory-> Minimum\Maximum server memory is 8GB

OK, SQL installation is complete, please pay attention to SQL version and sorting rules

The above is how to deploy SQL database in SCCM 2012R shared by Xiaobian. If you happen to have similar doubts, you may wish to refer to the above analysis for understanding. If you want to know more about it, please pay attention to the industry information channel.

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.