Solved

check if sql port is open

Posted on 2011-09-06
17
711 Views
Last Modified: 2012-06-21
is there any other option other than telnet to see if sql server port is open to another server?
0
Comment
Question by:25112
  • 7
  • 6
  • 2
  • +2
17 Comments
 
LVL 6

Accepted Solution

by:
markterry earned 126 total points
Comment Utility
netstat.
0
 
LVL 82

Assisted Solution

by:leakim971
leakim971 earned 249 total points
Comment Utility
0
 
LVL 6

Assisted Solution

by:markterry
markterry earned 126 total points
Comment Utility
run>cmd> netstat to see all open ports.
1433 = sql
or maybe you want this:
MS FIX IT
0
 
LVL 5

Author Comment

by:25112
Comment Utility
nertstat tells if the port is open, right?

i want to know if server a can access port 1433 on the sql server (let's call this serverb).. can you do that through netstat?
0
 
LVL 82

Assisted Solution

by:leakim971
leakim971 earned 249 total points
Comment Utility
netstat need to be run on the server itslef
go for sqlcmd
or what is your problem with telnet? you don't want to install it (win7/2k8?)
pkgmgr /iu:"TelnetClient"

Open in new window

0
 
LVL 82

Assisted Solution

by:leakim971
leakim971 earned 249 total points
Comment Utility
0
 
LVL 5

Author Comment

by:25112
Comment Utility
telnet can be installed by the windows admin only and he is not available for a few days..

1)you gave a link for: Microsoft® SQL Server® 2008 Management Studio Express
how will that help to see if server a can access serverb's port 1433?

2)is pkgmgr /iu:"TelnetClient" a sqlcmd?
0
 
LVL 82

Assisted Solution

by:leakim971
leakim971 earned 249 total points
Comment Utility
>how will that help to see if server a can access serverb's port 1433?
Install it on workstation/serverv and try to connect to server a.

>pkgmgr /iu:"TelnetClient" a sqlcmd?
this command install the telnet client on windows 7 & 2k8
but forget it if you don't have admin rights
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 82

Expert Comment

by:leakim971
Comment Utility
but you may try/run telnet on an other machine...
0
 
LVL 5

Author Comment

by:25112
Comment Utility
C:\Users\jimwe>pkgmgr /iu:"TelnetClient"

C:\Users\jimwe>

did not give any errors.. but nothing else either..

but i tried it and not it works..thanks..
0
 
LVL 5

Author Comment

by:25112
Comment Utility
>>netstat need to be run on the server itslef

so how would you check from netstat

C:\Users\TPBAdmin>netstat

Active Connections

  Proto  Local Address          Foreign Address        State
0
 
LVL 82

Expert Comment

by:leakim971
Comment Utility
Look for :1433 (local address)
Microsoft Windows [version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Tous droits réservés.

C:\Users\leakim>netstat -na

Connexions actives

 Proto  Local Address          Foreign Address        State
TCP    127.0.0.1:1433         0.0.0.0:0              LISTENING

C:\Users\leakim>

Open in new window

0
 
LVL 6

Assisted Solution

by:tangchunfeng
tangchunfeng earned 62 total points
Comment Utility
netstat -an|findstr 1433
or
telnet 192.168.1.2 1433
0
 
LVL 5

Author Comment

by:25112
Comment Utility
leakim971/tangchunfeng,

netstat will work only if the local machine is having SSMS installed and opened to a database, right?

with telnet, we will force it to listen and tell us if it can listen.


0
 
LVL 5

Author Comment

by:25112
Comment Utility

also can you help me to read
TCP    127.0.0.1:1433         0.0.0.0:0              LISTENING

is 1433 running on 127.0.0.1, and no one (0.0.0.0) is listening.
0
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 63 total points
Comment Utility
Try SQLPing. It is a free utility that allows you to quickly evaluate your SQL Server instances surface of exposure:

http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx

Hope this helps...
0
 
LVL 5

Author Comment

by:25112
Comment Utility
nice option..

thanks all.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now