Introduction

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

Ya

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:

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:

1433

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:

23232

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