Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to find SQL Server running port?

Tags:

sql-server

sql-server-2008

connection-string

Yes I read this How to find the port for MS SQL Server 2008?

no luck.

telnet 1433

returns connection failed, so I must specify other port.

I tried to use

netstat -abn

but I don't see sqlservr.exe or something similar on this list.

Why it so difficult to find that port? :/

like image 760
keram Avatar asked Sep 06 '12 09:09

keram

People also ask

What port SQL Server is running on?

By default SQL Server listens on TCP port number 1433, but for named instances the TCP port is dynamically configured.

How do I check if a port 1433 is open?

On the local machine, click the Start button and enter “CMD” in the search programs and files field. If the port 1433 is closed, an error will be returned immediately. If the port 1433 is open, you will be able to connect to the MS-SQL server.

1 Answers

Try this:

USE master GO xp_readerrorlog 0, 1, N'Server is listening on'  GO

http://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/

like image 55
AnandPhadke Avatar answered Sep 20 '22 07:09

AnandPhadke
Sign in to Comment

Related questions

SQL Server - When to use Clustered vs non-Clustered Index?
What is PAGEIOLATCH_SH wait type in SQL Server?
Replace Default Null Values Returned From Left Outer Join
Relationship of Primary Key and Clustered Index
Storing DateTime (UTC) vs. storing DateTimeOffset
Removing leading zeroes from a field in a SQL statement
How to create a unique index on a NULL column?
Partition Function COUNT() OVER possible using DISTINCT
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'
SQL Server datetime LIKE select?
Retrieve the maximum length of a VARCHAR column in SQL Server
Using StringWriter for XML Serialization
Using RegEx in SQL Server
Is there a way to retrieve the view definition from a SQL Server using plain ADO?
Current executing procedure name
How to convert SQL Server's timestamp column to datetime format
SQL Server Linked Server Example Query
SQL-Server: Is there a SQL script that I can use to determine the progress of a SQL Server backup or restore process?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!