Solved

MS sql 1433

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
xpath sql query 2008 8 42
NAS with google authentication 6 61
email about the whoisactive result 7 23
sql Total query 2 16
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Use of TCL script on Cisco devices:  - create file and merge it with running configuration to apply configuration changes
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

910 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now