Posts

PowerShell Script: Install-SQLServer

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 ...

Full setup including prerequisites

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...

IIS Installation and Application configuration windows swerver

Image
  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) – 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...

Here’s a step-by-step guide on configuring WDS on Windows Server

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...

how you can ensure or configure automatic time synchronization

How to install,Enable .Net 2.0 and 3.0 in windows 8 & 8.1, Windows Server 2012. step by step

Image
                                    Installation .Net 2.0 and 3.0 in windows 8 & 8.1 We can install offline and online both process availble below. Prerequisite for installtion  .net framework 1.    OS of 8 or 8.1. for offline 2. Internet for online Open a command prompt with administrator user rights (Run as Administrator) in Windows 8 or Windows Server 2012. To Install .NET Framework 3.5 feature files from Windows Update, use the following command: Copy Online :-------    DISM /Online /Enable-Feature /FeatureName:NetFx3 /All Copy Offline:-------- DISM /Image:C:\test\offline /Enable-Feature /FeatureName:NetFx3 /All /LimitAccess /Source:D:\sources\sxs Press Enter button.