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 → choose:

Database Engine Services

SQL Server Replication

Full-Text and Semantic Search

(optional) SQL Server Data Tools or Management Tools





---

4. Instance Configuration

Choose Default instance (MSSQLSERVER) or Named instance.



---

5. Server Configuration

Leave default service accounts or set domain accounts for enterprise use.

Set SQL Server Agent and SQL Server Browser to Automatic if needed.



---

6. Database Engine Configuration

Authentication:

Windows Authentication or

Mixed Mode → define sa password


Add your Windows user as administrator.



---

7. Complete Installation

Click Install and wait for success confirmation.


---

8. Install SQL Server Management Studio (SSMS)

Download from https://aka.ms/ssms.
Install and connect with:

Server name: localhost or .\SQLEXPRESS

Authentication: Windows or SQL



---

9. Enable Remote Access (optional)

1. In SSMS: Right-click server → Properties → Connections → enable Allow remote connections.


2. Open Windows Firewall → allow port 1433 (TCP) and 1434 (UDP).


3. Restart SQL Server service.




---

10. Verify

CREATE DATABASE TestDB;
GO
SELECT name FROM sys.databases;

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