PC SKILLS

✅ Step-by-Step: Create & Install Self-Signed Certificate in PowerShell 🟦 Step 1: Open PowerShell as Administrator 1. Click Start 2. Search PowerShell 3. Right-click → Run as Administrator 🟦 Step 2: Create a Self-Signed Certificate Use this command: New-SelfSignedCertificate -DnsName "test.local" -CertStoreLocation "Cert:\LocalMachine\My" 🔍 What this does: Generates a certificate for domain test.local Saves it under Local Machine → Personal → Certificates 🟦 Step 3: Export Certificate With Private Key (Optional) If you want a .pfx (for IIS / apps), run: 3.1 Set a password $mypwd = ConvertTo-SecureString -String "P@ssw0rd123" -Force -AsPlainText 3.2 Export to PFX Export-PfxCertificate -Cert "Cert:\LocalMachine\My\<Thumbprint>" ` -FilePath "C:\certs\mycert.pfx" -Password $mypwd 👉 Replace <Thumbprint> with your certificate’s real thumbprint: Get-ChildItem Cert:\LocalMachine\My 🟦 Step 4: Export .CER (For Trusted Root Ins...

PowerShell Script: Install-SQLServer.ps1 # PowerShell Script: Install-SQLServer.ps1 # Purpose: Fully automate SQL Server and SSMS installation # --- Variables --- $SQLDownloadURL = "https://go.microsoft.com/fwlink/?linkid=866658" # SQL 2022 Developer $SSMSDownloadURL = "https://aka.ms/ssmsfullsetup" $SQLInstaller = "C:\SQLServer2022.exe" $SQLMediaPath = "C:\SQLSetup" $ConfigFile = "C:\SQLSetup\ConfigurationFile.ini" $SSMSInstaller = "C:\SSMSSetup.exe" # --- Step 1: Download installers --- Write-Host "Downloading SQL Server..." Invoke-WebRequest -Uri $SQLDownloadURL -OutFile $SQLInstaller Write-Host "Downloading SSMS..." Invoke-WebRequest -Uri $SSMSDownloadURL -OutFile $SSMSInstaller # --- Step 2: Extract SQL Server setup files --- Write-Host "Extracting SQL Server installer..." Start-Process -FilePath $SQLInstaller -ArgumentList "/ACTION=Download /MEDIAPATH=$SQLMediaPath /QUIET" -Wait ...

1. Prerequisites Before installation, confirm the following: Hardware: CPU: 1.4 GHz or faster (2 GHz+ recommended) RAM: 2 GB minimum (4 GB+ recommended) Disk: 10 GB+ free space for setup 64-bit processor required (x64) Operating System: Windows Server 2016, 2019, 2022 Windows 10 or 11 (Pro or Enterprise) Software Requirements: .NET Framework 4.8 or higher Windows PowerShell 5.1 Microsoft Visual C++ Redistributable (auto-installed by setup) Administrative privileges Latest Windows updates applied Network (if using remote connections): Static IP or hostname TCP 1433 open in firewall SQL Browser service (UDP 1434) enabled if using named instances --- 2. Download From https://www.microsoft.com/sql-server. Choose: Developer Edition (full features, free for dev/test) Express Edition (free, limited resources) --- 3. Install 1. Run the installer → select Custom. 2. SQL Server Installation Center → New SQL Server stand-alone installation. 3. Accept license → proceed. 4. Feature Selection → choo...

  1.      Using the Server Manager, select  2 Add roles and features . Figure 4-9 Server Manager – Adding Roles and Features Select  Role-based or feature-based installation , and then click  Next . Choose  Select a server from the server pool . 4.      Select the server you are configuring, and then click  Next . Figure 4-10 Server Manager – Select Server 5.      Expand the  Web Server  role service. Figure 4-11 Server Manager – Web Server Role Services Expand the  Web Server  options and select the following  Common HTTP Features : ·         Default Document ·         ·         HTTP Errors ·         ·         Static Content · ...

 👥 Active Directory Users and Computers (ADUC) – Setup & Management Active Directory Users and Computers (ADUC) is one of the most essential tools for managing users, computers, and organizational units within an Active Directory environment. It allows administrators to organize, secure, and control all resources centrally. --- ⚙️ What ADUC Does ✅ Create and manage user and computer accounts ✅ Organize resources into Organizational Units (OUs) ✅ Assign permissions and access control ✅ Apply Group Policies to users and computers ✅ Enable or disable accounts and reset passwords --- 🧩 Step-by-Step: Install and Open ADUC Step 1️⃣ – Install ADUC Console 1. Open Server Manager → Manage → Add Roles and Features 2. Proceed to the Features section 3. Select RSAT: Active Directory Domain Services and Lightweight Directory Tools 4. Click Install 5. Once installed, go to Tools → Active Directory Users and Computers (On Windows 10/11 : Open PowerShell and run) Add-WindowsCapability -O...

Windows Deployment Services (WDS) is a Microsoft tool for network-based installation of Windows operating systems. It enables administrators to deploy Windows images over a network to computers without requiring physical media. Here’s a step-by-step guide on configuring WDS on Windows Server: Prerequisites: A Windows Server machine with WDS role installed. Active Directory, DNS, and DHCP set up and running on the network. An NTFS partition on the server to store images. Step 1: Install WDS Role Open Server Manager and go to Manage > Add Roles and Features . Click Next until you reach the Server Roles page. Select Windows Deployment Services and click Next . Choose WDS Deployment Server and WDS Transport Server and click Next . Complete the wizard to install the role, then restart the server if prompted. Step 2: Configure Windows Deployment Services Open WDS by navigating to Server Manager > Tools > Windows Deployment Services . In the WDS console, right-click on your se...