Connection to SQL server no longer works

Unanswered Question
Jun 28th, 2010
User Badges:

My office has a 3000 series VPN concentrator that has been managing our VPN traffic for a number of years.  Last week we suddenly lost the ability to connect to our SQL database server.  We are running an application called TIER that requires a logon.  We are able to get onto the network and access Exchange and our File Server, but the SQL server is no longer available.  The connection to the database times out.  We have not had this problem until last week.  Any help is greatly appreciated.


Error message attached.

Attachment: 
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Jennifer Halim Tue, 06/29/2010 - 04:56
User Badges:
  • Cisco Employee,

Does not sound like a VPN Concentrator issue, nor problem with the VPN. If the servers are in the same subnet, I don't see a reason why some servers are accessible, but the sql server is not.

I am suspecting it could be problem with firewall if there is any along the path, or even problem with the sql server itself. As far as connectivity is concern, are you able to ping the sql server?

thechildrensshelter Tue, 06/29/2010 - 05:49
User Badges:

Thank you for your reply.


I am in agreement with you but am at a loss.  I am able to ping the server when I VPN in but I can't access it.  I can access it directly on the network though.  I have not made any changes to the network and don't understand why this problem suddenly began.  I assumed it was a VPN issue as it only occurs while using VPN.


I changed our Domain DNS but I don't see how that would affect what I am doing.  Especially since I am able to VPN into the network itself.


All insight is appreciated.

damianhinojosa Tue, 06/29/2010 - 06:24
User Badges:

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

Hello


If I were you, I’d try:


1)

I don’t trust GUI clients, so using the command line try to telnet to the SQL port (usually 1433) of the server. telnet [server ip] 1433

Then try the server name: telnet [server name] 1433

2)

Using Wireshark  (or Ethereal, windump, etc) see if the server sees your incoming connection at all.


3)

Maybe check the routing. I assume that your VPN clients would have a pool of network addresses. Check that the SQL server knows how to route back to that range. Although your ping works, so this might not be the issue but it is worth checking.



I suggest using KiwiCat tools to take daily backups of your VPN appliances. This tool will tell you if there have been any configuration changes from one day to another. It’s worth it…..


Good luck,


Damian

thechildrensshelter Tue, 06/29/2010 - 08:59
User Badges:

Thank you for your response.


I ran a netstat -a -n on the server in question and saw that port 1433 was indeed responding to people on the network, so the port is definitely open.  Still, I have no idea as to why, when I VPN into the server, I am getting the error I mentioned before.  I can ping the server when I VPN in and can even map a drive to it but I cannot run the SQL application.


I realize this problem may not be VPN related.  Thank you

Actions

This Discussion

Related Content