Solved

MS sql 1433

Posted on 2014-03-27
4
235 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

As companies replace their old PBX phone systems with Unified IP Communications, many are finding out that legacy applications such as fax do not work well with VoIP. Fortunately, Cloud Faxing provides a cost-effective alternative that works over an…
Use of TCL script on Cisco devices:  - create file and merge it with running configuration to apply configuration changes
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

717 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