Windows 10 VPN and SQL with Meraki VPN

%3CLINGO-SUB%20id%3D%22lingo-sub-1169397%22%20slang%3D%22en-US%22%3EWindows%2010%20VPN%20and%20SQL%20with%20Meraki%20VPN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1169397%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%20when%20our%20users%20connect%20to%20VPN%20(Windows%2010%20VPN%20on%20Meraki)%20they%20used%20to%20be%20able%20to%20access%20a%20client%20application%20on%20a%20SQL%20server%20host%20(a%20Windows%2010%20host)....but%20something%20recently%20happened%20on%20the%20host%20(uninstalled%20Norton%20security%20and%20it%20likely%20reset%20a%20bunch%20of%20stuff)%20and%20now%20client%20VPN%20users%20are%20no%20longer%20able%20to%20access%20that%20application....we%20can%20ping%20the%20SQL%20host%20from%20the%20client%20device%20after%20connecting%20to%20VPN%20but%20no%20longer%20access%20the%20application%2C%20so%20my%20guess%20its%20some%20Windows%20firewall%20port%20or%20protocol%20on%20the%20SQL%20server%20blocking%20the%20traffic%20when%20it%20sees%20the%20traffic%20coming%20in%20via%20VPN%20because%20it%20works%20fine%20within%20the%20network%2C%20and%20its%20not%20as%20permission%20issue%20as%20I%20put%20the%20same%20client%20device%20on%20the%20network%20and%20it%20can%20access%20the%20application%20without%20any%20issues.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EAny%20thoughts%20or%20ideas%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1169397%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecisco%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENetworking%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Evpn%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWindows%2010%20Pro%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1171693%22%20slang%3D%22en-US%22%3ERe%3A%20Windows%2010%20VPN%20and%20SQL%20with%20Meraki%20VPN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1171693%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EWhich%20Windows%2010%20version%20are%20you%20using%3F%3CBR%20%2F%3Ehave%20you%20contacted%20Norton%20support%20about%20it%3F%20since%20the%20problem%20started%20happening%20after%20uninstalling%20that%20software%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1171695%22%20slang%3D%22en-US%22%3ERe%3A%20Windows%2010%20VPN%20and%20SQL%20with%20Meraki%20VPN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1171695%22%20slang%3D%22en-US%22%3EAlso%20try%20SQL%20server%20community%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsql-server%2Fct-p%2FSQL-Server%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsql-server%2Fct-p%2FSQL-Server%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1171757%22%20slang%3D%22en-US%22%3ERe%3A%20Windows%2010%20VPN%20and%20SQL%20with%20Meraki%20VPN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1171757%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F310193%22%20target%3D%22_blank%22%3E%40HotCakeX%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20both%20server%20and%20host%20are%20Win10%20Pro%2C%20and%20no%20haven't%20contacted%20Norton%20because%20I%20don't%20think%20they%20could%20help%20with%20this%20since%20its%20after%20the%20uninstall%20it%20stopped%20working.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1172900%22%20slang%3D%22en-US%22%3ERe%3A%20Windows%2010%20VPN%20and%20SQL%20with%20Meraki%20VPN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1172900%22%20slang%3D%22en-US%22%3EI%20mean%20the%20version%20which%20is%20a%20number%20not%20the%20edition.%3CBR%20%2F%3Ewell%20I%20don't%20know%2C%20technically%20it's%20their%20software%20that%20causes%20this%20issue%20and%20I'm%2099%25%20sure%20after%20reinstalling%20Windows%20the%20problem%20will%20go%20away.%3CBR%20%2F%3Eprobably%20the%20uninstall%20procedure%20of%20Norton%20wasn't%20complete%20and%20there%20are%20some%20leftovers%20on%20the%20system%20causing%20problems.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi, when our users connect to VPN (Windows 10 VPN on Meraki) they used to be able to access a client application on a SQL server host (a Windows 10 host)....but something recently happened on the host (uninstalled Norton security and it likely reset a bunch of stuff) and now client VPN users are no longer able to access that application....we can ping the SQL host from the client device after connecting to VPN but no longer access the application, so my guess its some Windows firewall port or protocol on the SQL server blocking the traffic when it sees the traffic coming in via VPN because it works fine within the network, and its not as permission issue as I put the same client device on the network and it can access the application without any issues.

Any thoughts or ideas?

4 Replies
Highlighted
Hi,
Which Windows 10 version are you using?
have you contacted Norton support about it? since the problem started happening after uninstalling that software?
Highlighted
Highlighted

@HotCakeX 

 

I believe both server and host are Win10 Pro, and no haven't contacted Norton because I don't think they could help with this since its after the uninstall it stopped working.

Highlighted
I mean the version which is a number not the edition.
well I don't know, technically it's their software that causes this issue and I'm 99% sure after reinstalling Windows the problem will go away.
probably the uninstall procedure of Norton wasn't complete and there are some leftovers on the system causing problems.