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
ASKER CERTIFIED SOLUTION
Avatar of Suliman Abu Kharroub
Suliman Abu Kharroub
Flag of Jordan image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of DwightIVD
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
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo