I'm hosting an SQL server on a pc that runs ubuntu. I can connect using SSMS with a windows laptop through vpn which gives me a local ip like 10.0.8.0.
However a windows pc that is within the same subnet can't connect with the same credentials that i use with my laptop. The error i get is
"Named Pipes Provider, error: 40 - Could not open a connection to SQL Server" I've tried to specify the server instance and different connection methods.
I even tried to set up a second sql server outside my network and connecting with the troubled pc (also through vpn) ... and that somehow works.
So my question is: what is allowing connections with devices that are in the network through vpn and excluding devices that are in the same subnet?
Is my servername flat out wrong?
ive tried: the localip of the server (which works on vpn), the name of the server (which doesnt work anywhere), the localip and a server instance name...