Avatar of DwightIVD
DwightIVD
 asked on

MSSQL Connection times out on first attempt.

I have a production environment with an MSSQL 2008 server and two domain controllers running on Server 2003 and acting as the DNS servers.  The environment had been working fine for about 2 years - but recently I started having a strange problem.  When I try to connect to MSSQL I get a timeout on my first attempt, but connect OK on my second attempt.  My workstation is on the domain and using the two DC's as DNS servers.  This seems to be DNS related.  I hang up when connecting to the direct IP, or the server name, but on management studio can get in on the first attempt   using the FQDN of p21sql.ivd1.local.  Other domain users are having the same problem.  In addition some are having very slow connection times to web sites (but throughput is fine - so again I think it is DNS related).

The same problem occurs using my ERP system which connects to the DB server.  I get a connection error but connect on the retry.

I am not using dynamic ports on SQL, and 1443 is open on my Sonicwall and on the SQL server firewall.  The firewall is temporarily off on the workstation.  

I'd appreciate any troubleshooting tips.

Thanks
Microsoft SQL ServerInternet ProtocolsDNS

Avatar of undefined
Last Comment
DwightIVD

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Suliman Abu Kharroub

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
DwightIVD

ASKER
Thanks for the suggestion.  The SQL server is busy but not overloaded.  I can actually recreate the exact same behavior to another SQL server with almost no activity.  The 1st login fails every time, and succeeds on the retry every time.  I really think it's some kind of DNS or AD issue
Your help has saved me hundreds of hours of internet surfing.
fblack61