Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is Port 1433 open?
Message
 
 
À
06/06/2017 17:14:10
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Divers
Thread ID:
01651803
Message ID:
01651817
Vues:
38
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform