Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is Port 1433 open?
Message
 
 
À
07/06/2017 17:18:08
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Divers
Thread ID:
01651803
Message ID:
01651848
Vues:
40
>>The problem was resolved by starting the SQL Server Browse service on the server. What is strange, that before this service started, many PCs using the VFP app with SQL Server didn't have a problem. But then one PC (newer) had the problem. So I will make a note to always start the SQL Server Browse service.
>
>This seems a little bit unorthodox.
>
>First of all, if you have a firewall, all VM having a need to communicate with SQL Server will need to have their port 1433 opened towards SQL Server. That assumes SQL Server is also hosted on another VM. Thus, all Web servers and application servers, for example, would need to have TCP/UDP opened, for the inside interface, as we assume all would be denied by default.
>
>On your end, it appears, either there was no definition or specific rules were added to support that as this was working for all servers except one.
>
>There shouldn't be a need to start the service you mentioned, on the SQL Server itself, to workaround the issue. I have some doubt this is even related. Could there have been some other changes, meanwhile, that would have made that work at the same time?

It was within literally 10 minutes when the customer sent me email saying that they check everything, as far as firewall or AV and were still getting error. And then I started the SQL Server Browser service and asked him to try again. And he said "everything works now." It is, of course, possible that something else may have occurred at the same time. But I don't know.
"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