SQL सर्वर स्थापना तैयारी: विंडोज़ फ़ायरवॉल नियम बनाना, तार्किक डिस्क, .NET फ्रेमवर्क स्थापित करना 3.5, और सेवा खाते बनाना.
Create Windows Firewall rules for SQL
1. Log in to your SQL server. दायाँ माउस बटन पर क्लिक करें शुरू बटन दबाएं और चुनें Control Panel;
2. खुला Windows Firewall;
3. पर क्लिक करें Advanced settings;
4. पर क्लिक करें Inbound Rules और चुनें New Rule;
5. विकल्प चुनें Port and click the अगला बटन;
6. Select options UDP, Specific local ports और दर्ज करें 1434 and click the अगला बटन. (Default SQL UDP port, allow remote connections to SQL);
7. Leave Allow the connection and click the अगला बटन;
8. Leave check marks by default and click अगला;
9. Enter the rule name, for an example SQL UDP, and click the खत्म करना बटन;
10. Repeat and select the TCP विकल्प, Specific local ports, और दर्ज करें 1433. (Default SQL TCP port). भी, I enter 14331 और 8080 after the symbol “,” for my future SCCM installation. क्लिक the अगला बटन;
11. Repeat, enter the rule name, for example, SQL TCP, and click the खत्म करना बटन;
12. Check created tules;
Create logical disks
Create logical disks. Early I create और connect to my SQL VM two “Virtual Disks“. In this post, we initialize them and create “Logical disks” in the system.
1. दायाँ माउस बटन on the “शुरू” button and select “डिस्क प्रबंधन“;
2. First of all change the “CD-ROM” drive letter from “D" को "R“. दायाँ माउस बटन click on CD-ROM and select Change Drive Letter and Paths;
3. क्लिक करें परिवर्तन बटन;
4. Select the drive letter “R” and click the ठीक है बटन;
5. In the pop-up window click the हाँ बटन;
6. क्लिक करें ठीक है button to apply changes;
7. दायाँ माउस बटन click on the first Disk and select Online;
8. दायाँ माउस बटन click on the first Disk and select initialize Disk;
9. Select option “GPT (GUID Partition Table)” and click “ठीक है" बटन;
10. दायाँ माउस बटन click on first Disk “Unallocated space” and select “New Simple Volume” (to create new logical disk);
11. क्लिक करें "अगला" बटन;
12. Leave size as default and click the “अगला" बटन;
13. Assign a drive letter, as an example “D" और " पर क्लिक करेंअगला" बटन;
14. Set format options:
- File System – leave “NTFS“, if you use “ReFS” – you can’t backup it with “डीपीएम” (Data Protection Manager doesn’t understand ReFS);
- Allocation unit size – I set “64K” because I place on disk a few big files;
- Volume label – set the name for your drive. In my case “SCCM-DATA“.
क्लिक करें "अगला" बटन;
15. Check the summary information and click the “खत्म करना" बटन;
16. Repeat for the second disk;
17. Open “This PC” and check newly added “Logical Disks”;
Install Net Framework 3.5
You can install it using अध्यक्ष एवं प्रबंध निदेशक or GUI. In this post, we install “NET Framework 3.5” from GUI.
1. If Server Manager doesn’t start at login – run it. Click on the upper menu “Manage” and select “Add Roles and Features”;
2. क्लिक करें "अगला" बटन;
3. क्लिक करें "अगला" बटन;
4. Select your target server and click the “अगला" बटन;
5. Don’t install any roles, click the “अगला" बटन;
6. Set the check mark on “.NET Framework 3.5 Features” and click the “अगला" बटन;
7. क्लिक करें "स्थापित करना" बटन (if you don’t have an internet connection, but insert DVD or *.iso file with operating system installation files – click “Specify an alternate source path” <drive letter>:\sources\sxs);
8. When the installation is complete click the “बंद करना" बटन;
Create Service Accounts
1. For my SQL & SCCM deployment I create folders:
- On disk “D” (“SCCM-DATA“) – SCCM and sub-folders (बैकअप, Data, लॉग्स);
- On disk “E” (“TEMP“) – SCCM;
You plan and deploy SQL as you wish or by your “Corporate Policies“.
2. Let’s add “Service accounts” for SQL and SCCM deployment. दायाँ माउस बटन click on the “शुरू” button and select “Computer Management”;
3. Go to “Groups” and open “व्यवस्थापकों“;
4. क्लिक करें "जोड़ना" बटन;
5. First add the SCCM server (“AD Object Computer“) account. अगला, add all SQL service accounts and SCCM service accounts (for client installation); After adding click the “ठीक है" बटन;
6. Also you may enable in “Windows Firewall” rule to allow ping;
7. And enable more rules (स्क्रीनशॉट देखें) for successful SCCM deployment.
8. If you don’t do step “7” you may get the next error when installing SCCM;