While I have read a lot in the forum about the issues with connecting from other terminals to the sql server and all the issues with the Firewalls, I was able to properly set the exceptions and connect perfectly fine from 2 of the terminals… however, 2 other terminals, on the same network, with the same software installed (Windows 11) throw up : Named Pipes Provider, error: 40 - Could not open a connection to SQL Server… which in my opinion does not make sense, as I have right next to the machine that throws that error an identical machine which connects without a problem. When I switch off the firewall on the server, then the second machine can connect, but the moment I switch the firewall back on, the first one can still connect but the second one right next to it, throws again the error.
I compared the two machines… same network, same OS, same SambaPOS version, same .NET version, same outgoing firewall settings … everything exactly the same, except one is a Microsoft Laptop and the other a Lenovo Laptop but that should not make a difference, should it?
Anybody with an idea why this is happening, would be highly appreciated.
Static ip or dynamic?
You connecting with hostname or ip?
Id guess maybe something differing with network config, ipv6 or something like that.
Try checking the names pipes setup in sql config and or try setting connection string using fixed ipv4 address.
I connect with Host Name and dynamic IPs from the DHCP as the server is in one location of the resort and the stations are in different locations, but still all on the same network. I even thought maybe it’s a Router issue, so, I tested the stations all connected to the same Router as well as to routers further in the resort, still with same result, 2 connect, 2 do not connect and throw the error.
I compared the network configurations, and they are exactly the same, no IPv6 used at all…
I tried connecting with IP string instead of HOST name, then none of the stations connect, not even the two who are connecting properly with the host name.
In regard to the SQL set-up, I am not sure what could be wrong there as 2 of the stations connect just fine, just the other two not and the moment I switch off the firewall, all stations connect, so I am not sure it has anything to do with the SQL…
I agree 100% on the firewall issue, but how is it possible that it lets 2 terminals through and 2 other terminals not (again, identical terminals standing next to each other on the same router and the same network) … that is what is killing me…
I checked all the exceptions in the firewall, they are correctly in and active also for the correct ports and checked also again the outgoing firewall on all the stations and even there everything is exactly the same…
OK, as mentioned in the other post already, we have for the time being moved the SQL server from the win 10 to the win 11 machine and upgraded to SQL Server 2022…
Also, all firewalls are disabled for the time being, will test the exceptions in the next few days, if all changes we made achieved the expected results…
Thanks to everybody for the suggestions and help, especially Nizam for the time spent with me on Anydesk
