Introduction

Jab hum Microsoft SQL Server install karte hain, tab kuch important tools automatically install ho jate hain. Unme se ek bahut important tool hai:

SQL Server Configuration Manager

SQL Server Configuration Manager Kya Hai

SQL Server Configuration Manager ek graphical management tool hai jo SQL Server ke different components ko configure aur manage karne ke liye use hota hai.

Is tool ke through hum:

SQL Server services start/stop kar sakte hain
Network protocols enable/disable kar sakte hain
SQL Server port change kar sakte hain
Service accounts manage kar sakte hain
Startup parameters configure kar sakte hain

Ye tool actually Microsoft Management Console (MMC) snap-in hota hai.

SQL Server Configuration Manager Ka Use

Is tool ka use mainly 3 major purposes ke liye hota hai:

1️⃣ SQL Server Services Manage Karna

Example:

SQL Server Engine start / stop
SQL Server Agent manage karna
SQL Server Browser manage karna

2️⃣ Network Protocols Configure Karna

Example:

TCP/IP enable karna
Named Pipes enable karna
SQL Server port change karna

3️⃣ Client Connectivity Manage Karna

Example:

SQL Server client connections configure karna
Network communication settings manage karna

SQL Server Configuration Manager Open Kaise Kare

Configuration Manager open karne ke multiple ways hain.

Method 1 – Start Menu

Path:

Start Menu
Microsoft SQL Server
SQL Server Configuration Manager

Method 2 – Run Command

Run dialog open karo aur type karo:

SQLServerManager13.msc

Ye command SQL Server 2016 ke liye hoti hai.

Different SQL Server versions ke liye command different hoti hai.

Example:

SQL Version	Command
SQL 2012	SQLServerManager11.msc
SQL 2014	SQLServerManager12.msc
SQL 2016	SQLServerManager13.msc
SQL 2017	SQLServerManager14.msc
SQL 2019	SQLServerManager15.msc

SQL Server Services

Configuration Manager ka sabse important section hota hai:

SQL Server Services

Yaha SQL Server ke saare running services dikhte hain.

Example services:

SQL Server Engine
SQL Server Agent
SQL Server Browser
SQL Server Integration Services

SQL Server Engine

Ye SQL Server ka core service hai.

Agar ye service stop ho jaye to:

Database access possible nahi hoga
Applications connect nahi kar payengi
Queries run nahi hongi

SQL Server Agent

Ye service automation ke liye use hoti hai.

Example tasks:

Scheduled backups
Data imports
Maintenance jobs
Automated reports

SQL Server Browser

Ye service help karta hai:

Multiple SQL Server instances detect karne me
Client applications ko correct instance locate karne me

Services Start / Stop / Restart

Configuration Manager se aap services control kar sakte ho.

Right click service → options:

Start
Stop
Restart
Pause

Example:

Agar SQL Server hang ho gaya hai to DBA usually karta hai:

Restart Service

Service Account

SQL Server ek Windows account ke under run karta hai.

Example:

NT SERVICE\MSSQLSERVER

DOMAIN\DBAdmin

Ye account SQL Server ko:

file access
network access
permissions

provide karta hai.

Real Production Example

Large companies me service accounts alag hote hain:

Domain\DB_SQLSERVER
Domain\DB_SQLAGENT

Security aur auditing ke liye ye best practice hota hai.

Startup Mode

Service ka startup mode define karta hai ki server restart hone par service ka behaviour kya hoga.

Options:

Mode	Meaning
Automatic	Server start hote hi service start
Manual	User manually start karega
Disabled	Service kabhi start nahi hogi

Best Practice

Production environment me usually:

Startup Mode = Automatic

Taaki server restart hone par SQL Server automatically start ho jaye.

Startup Parameters

SQL Server start hone ke time kuch important parameters use karta hai.

Example parameters:

Master database path
Error log path
SQL Server configuration values

Example startup parameters:

-d master.mdf path
-l mastlog.ldf path
-e errorlog path

Important Point

Master database SQL Server ke startup ke liye mandatory hoti hai.

Agar master database corrupt ho jaye to:

SQL Server start nahi hoga

Isliye master database ka backup bahut important hota hai.

Network Protocols

Configuration Manager me ek important section hota hai:

SQL Server Network Configuration

Yaha SQL Server ke network protocols manage hote hain.

Default protocols:

Shared Memory
Named Pipes
TCP/IP

Shared Memory

Ye protocol local connections ke liye use hota hai.

Example:

SSMS same machine par run ho raha hai

Named Pipes

Ye ek legacy protocol hai.

Mostly old applications use karti hain.

Modern systems me generally disabled hota hai.

TCP/IP

Ye sabse important protocol hai.

Almost saari applications SQL Server se connect karti hain using:

TCP/IP

Example:

Web applications
Power BI
Python scripts
.NET applications

SQL Server Default Port

SQL Server ka default port hota hai:

Matlab SQL Server network traffic listen karta hai port 1433 par.

Example connection:

ServerName:1433

Port Change Karna

Security reasons ki wajah se kabhi kabhi DBA default port change karta hai.

Example:

1433 → 23232

Isse hackers ko SQL Server detect karna difficult ho jata hai.

Port Change Steps

Configuration Manager me:

Protocols for SQL Server
TCP/IP → Properties
IPAll → TCP Port

Example:

Phir SQL Server restart karna padega.

Dynamic Port vs Static Port

SQL Server me do types ke ports hote hain.

Dynamic Port

Port automatically change hota hai server restart hone par.

Example:

TCP Dynamic Ports

Static Port

Port manually defined hota hai.

Example:

TCP Port = 23232

Production me static port recommended hota hai.

SQL Server Logs Me Port Verify Karna

Port change hone ke baad verify karne ke liye SQL Server logs check karte hain.

Path:

Management
SQL Server Logs

Log message example:

Server is listening on port 1433

Agar port change hua hai:

Server is listening on port 23232

Important Security Tip

Default port use karna risky ho sakta hai.

Example:

Agar hacker server scan kare to:

Port 1433 open

Iska matlab:

SQL Server present hai

Isliye kuch companies port change kar deti hain.

Real World DBA Scenario

Example situation:

Application SQL Server se connect nahi ho rahi.

DBA steps:

1️⃣ Check SQL Server service running hai ya nahi
2️⃣ Check TCP/IP enabled hai ya nahi
3️⃣ Check correct port configured hai ya nahi
4️⃣ Check firewall port open hai ya nahi

Most connection issues yahi se solve ho jate hain.

Best Practices for SQL Server Configuration

✔ SQL Server service automatic start par rakho
✔ Default port change kar sakte ho security ke liye
✔ TCP/IP protocol enable rakho
✔ Service accounts properly configure karo
✔ Changes ke baad SQL Server restart karo

Results for "Pipes"

SQL Server Configuration Manager