[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

MS sql 1433

Posted on 2014-03-27
4
Medium Priority
?
258 Views
Last Modified: 2014-08-06
We use fingbox for network remote discovery as well as to alert our team if a host or service goes down. Recently we've been getting alerted multiple times in a day (20 times) that the mssql 1433 port is going down and coming right back up within a few seconds. I've checked all logs and for some strange reason I cannot find anything. Has anyone experienced this type of behavior with that sql port in particular and what they did to resolve it. Sql 2008r2 has all the latest sp's installed as well as the servers is up to date with all patches etc.

Thanks in advance for your help
0
Comment
Question by:visionsupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 51

Expert Comment

by:Mark Wills
ID: 39961118
Sounds like a network config problem.

You could try setting “TcpMaxDataRetransmissions" to a higher value.

It is explained in : http://blogs.msdn.com/b/sql_protocols/archive/2006/03/09/546852.aspx

Failing that, might want to download netmon and run some traces / diagnostics, the next link is a bit of a walkthrough as to how they found their TCP/IP problem : https://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/06/18/using-network-trace-to-troubleshoot-intermittent-connectivity-issues.aspx

Failing that, last choice (and maybe hardware guys would say first choice) could be a (network) hardware problem...
0
 
LVL 17

Expert Comment

by:TimotiSt
ID: 39962415
What do you test? Just the TCP connection, or login, or even run a query?
Intermittent errors can be DNS issues (forward or reverse).

Tamas
0
 

Accepted Solution

by:
visionsupport earned 0 total points
ID: 40234326
The problem was a faulty network adapter. Thank you for your responses...
0
 

Author Closing Comment

by:visionsupport
ID: 40243168
It had nothing to do with sql
0

Featured Post

Q2 2017 - Latest Malware & Internet Attacks

WatchGuard’s Threat Lab is a group of dedicated threat researchers committed to helping you stay ahead of the bad guys by providing in-depth analysis of the top security threats to your network.  Check out our latest Quarterly Internet Security Report!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Quality of Service (QoS) options are nearly endless when it comes to networks today. This article is merely one example of how it can be handled in a hub-n-spoke design using a 3-tier configuration.
Use of TCL script on Cisco devices:  - create file and merge it with running configuration to apply configuration changes
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question