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

# --- Step 3: Create Configuration File ---
Write-Host "Creating configuration file..."
@"
[OPTIONS]
ACTION="Install"
FEATURES=SQLENGINE
INSTANCENAME="MSSQLSERVER"
SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
SECURITYMODE="SQL"
SAPWD="P@ssw0rd123"
SQLSYSADMINACCOUNTS="$env:USERNAME"
TCPENABLED="1"
NPENABLED="0"
IACCEPTSQLSERVERLICENSETERMS="True"
"@ | Out-File -FilePath $ConfigFile -Encoding ASCII

# --- Step 4: Run silent SQL Server installation ---
Write-Host "Installing SQL Server..."
Start-Process -FilePath "$SQLMediaPath\setup.exe" -ArgumentList "/ConfigurationFile=$ConfigFile /QUIET /NORESTART" -Wait

# --- Step 5: Open firewall ports ---
Write-Host "Configuring firewall..."
netsh advfirewall firewall add rule name="SQL Server TCP 1433" dir=in action=allow protocol=TCP localport=1433
netsh advfirewall firewall add rule name="SQL Browser UDP 1434" dir=in action=allow protocol=UDP localport=1434

# --- Step 6: Install SSMS silently ---
Write-Host "Installing SQL Server Management Studio..."
Start-Process -FilePath $SSMSInstaller -ArgumentList "/install /quiet /norestart" -Wait

# --- Step 7: Verify installation ---
Write-Host "SQL Server and SSMS installation completed."
Write-Host "You can now connect using SSMS to 'localhost' with Windows Authentication."


---

How to Use

1. Save the above script as Install-SQLServer.ps1.


2. Open PowerShell as Administrator.


3. Run:

Set-ExecutionPolicy Bypass -Scope Process -Force
.\Install-SQLServer.ps1




---

Result

SQL Server 2022 Developer installed silently.

SSMS installed silently.

TCP port 1433 and UDP 1434 open for remote access.

Default instance: MSSQLSERVER

sa password: P@ssw0rd123 (change it later).

Comments

Post a Comment

Popular posts from this blog

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

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 · ...
Read more

IIS Self Signed

-
Image
  Securing the server with SSL Now we want to secure the cats by adding a SSL certificate to our Server. In your IIS Manager go to your server (The top of the tree to the left)  ➜  Scroll down and double-click Server Certificates. (If your self-signed certificate is already here, jump ahead to the bindings steps) We need to import our self-signed server certificate in order to enable https communication with SSL, so click Import… Click the … and find your .pfx file, fill out the password (the -po parameter in your command batch file) and click OK Your certificate is now added Double-click the newly added cert to verify that it is trusted (Your self-signed certificates were added to the correct stores in my previous post, so again: read it if you are lost right now ;-)) So far, so good! Now we can add the https binding, the same way as before but choose https with port 443, your domain as the host name and find yourself signed certificate in the drop do...
Read more