April 8, 2015 at 4:30 am
Hi
I have SQL Server 2012 installed on my local machine as the default instance. There are no other versions on my PC.
Every time after I'n connected to a customer's VPN, my SQL Server stops working, and I have to restart my PC. Stopping and starting the service also does not work.
What can it be? Anything that I can do (besides reinstalling)?
April 9, 2015 at 1:23 am
I guess there is no SQL Server issue. Are you able to run SQL SERVER in the physical network which are you connecting through VPN? Connecting/disconnecting the VPN might have some issue it is not clearing and login off completely which might create this issue.
Are you a local admin on your pc? On which account SQL Server services are running? Can you check and provide the error log what error you are getting?
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 1:52 am
Thanks for reply.
1. Yes, I can use SQL Server on the network to which the VPN is connected on. When I disconnect the VPN, all my other services like mail and internet are working, so if there's a problem with disconnection it's very specific to SQL.
2. Yes, I am Admin on my PC.
3. SQL is running on NT Service\MSSQLSERVER
4. Error after VPN disconnect: Connection Timeout Expired. The timeout period elapsed while attempting to sonsume the pre-login handshake acknowledgement...
April 9, 2015 at 3:54 am
I guess firwall/port might be the issue. Can you try to telnet the port you are using for sql server which is accessible after VPN?
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 4:03 am
Good guess, but...
I can telnet before connecting to the VPN. But after the VPN the telnet does not work.
I only have the Windows standard firewall enabled, but even if I turn it off the telnet does not connect.
April 9, 2015 at 4:59 am
Yes, that is the problem. Once you resolve the port issue after connecting to VPN; you will able to connect.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 5:06 am
So you were right that it is not a SQL Server issue, hence the wrong forum for this discussion going forward.
Any good suggestions about network forums? There are so many and I haven't used them before.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply