C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
.NET
ADO.NET
Android
ASP.NET
C#
Databases & DBA
Design Patterns & Practices
iOS
Java
OOP/OOD
SharePoint
Software Testing
Web Development
WPF
View All
13
Reply
On Which Port Does Sql Server Runs
Vithal Wadje
11y
2.5k
0
Reply
Delete Row
Delete Column
Insert Link
×
Insert
Cancel
Embed YouTube Video
×
Width (%)
Height (%)
Insert
Cancel
Table Options
×
Rows
Columns
First row as header
Create Table
Insert Image
×
Selected file:
Alignment
Left
Center
Right
Select an image from your device to upload
Upload to Server
Cancel
Submit
The Default port is 1433 for TCP/IP and 1434 for USD connection.
Ashu Bahl
11y
2
The default port is 1433 (TCP). But you can configure the SQL DB engine to listen the port you want.
Jaganathan Bantheswaran
11y
2
By default it is 1433.to know port number follow the below steps in the registry section HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp
Yadagiri Reddy
11y
1
Default Port for Sqlserver : 1433 for TCP/IP and 1434 for USD connection. -------------------------------------------------------------------------------- Method 1: using xp_readerrorlog: Execute following stored procedure on the instance where you want to find out port on which SQL Server is running. USE MASTER GO xp_readerrorlog 0, 1, N'Server is listening on' GO -------------------------------------------------------------- Method 2: Configuration Properties a)Go to Windows >> Start >> SQL Server Program Folder >> SQL Server Configuration Manager b)Now go to SQL Server Network Configurations >> Protocols for Your c)Server and go to TCP/IP and right click over it. Now when you scroll down you will notice Port Details.
Rohit Vyas
11y
0
Default port is 1433 for TCP/IP and 1434 for USD connection.
Alok Gupta
11y
0
1433
Garima Jain
11y
0
Default Port for SQL server is 1433.
Garima Jain
11y
0
1433
Naresh
11y
0
1433
Shweta Lodha
11y
0
IPv6 loopback and IPv4 loopback port(1434) IPv6 unspecified and IPv4 unspecified port(1433)
Pulak deb
11y
0
USE master GO xp_readerrorlog 0, 1, N'Server is listening on' GO
Munesh Sharma
11y
0
use default port no 1433
Vishvajeet Pawar
11y
0
yes,TCP 1433
Vithal Wadje
11y
0
What is difference between HTML Server control and Asp.net Server Control ?
What Is recursive Cursor in Sql server ?
Message