Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is Port 1433 open?
Message
 
 
To
07/06/2017 17:18:08
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
01651803
Message ID:
01651848
Views:
39
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform