Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is Port 1433 open?
Message
 
 
To
06/06/2017 17:14:10
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
01651803
Message ID:
01651817
Views:
37
>>Hi,
>>
>>I need to check if a client computer has port 1433 open. This client (unlike other client PCs) has a problem connecting to the SQL Server. When I Google for "how to find if port 1433 is open" I come across messages pointing to the TELNET command. I tried telnet on my computer (in Command prompt) but get the message that this command "is not recognized ...". Is there another command that will quickly tell me (on that client PC) if port 1433 is open or not?
>>
>>TIA
>
>If you have PowerShell available, you can test networks connections.
>
>At the program prompt, enter powershell (or search for it), and at the powershell prompt, issue a Test-NetConnection command in the form
>
>
>Test-NetConnection -ComputerName www.levelextreme.com -Port 80
>
>
>(exchange the computer name and port for the ones you want to test). Something like this will be returned (but not with parts in Portuguese, I'll presume):
>
>
>ComputerName     : www.levelextreme.com
>RemoteAddress    : 64.18.88.26
>RemotePort       : 80
>InterfaceAlias   : Ligação de rede sem fios
>SourceAddress    : 192.168.1.71
>TcpTestSucceeded : True
>
First, thank you. It appears that I have Powershell on my computer. Tomorrow I will get a connection to the customer computer to test. But here is what I don't understand. If I want to test connection to the SQL server (customer SQL server) how would I change the Test-netconnection? Say, I change the "computername" with the VM computer name where SQL is installed. But where would I indicate the SQL server name? Because I am trying to determine if the PC has connection to the SQL Server.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform