Receiving timeout errors on SQL2014

Question

Post reply

Receiving timeout errors on SQL2014

Dhruva_51

SSChampion

Points: 10521
More actions
July 21, 2019 at 10:05 pm

#3664892

Similar to the one mentioned in the below article. We are sql server build number 12.0.5589 and windows server 2012R2. Server doesn't accepts new connections and doesn't respond.
https://support.microsoft.com/en-us/help/2919863/you-receive-time-out-error-messages-when-you-connect-to-a-sql-server-2

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80320 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

VastSQL SSC-Dedicated Points: 36067 More actions · Answer 2

Did you get a chance to check the logs?(SQL Logs & Windows)

Sue_H SSC Guru Points: 90860 More actions · Answer 3

In addition to checking the logs, you can login with the DAC and check what is going on with the system - locks, blocks, waits, system health extended events, etc.

Sue

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 4

You are more than a year behind on SQL Server cumulative updates. I can only imagine but would suspect that you're probably behind on Windows Updates, as well. If for no other reason, you need to update to the latest and greatest on both for security reasons. It might also fix your current problem.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 5

I know it sounds crazy but I just went through something similar just 15 minutes ago. The problem was that the SQL Service wasn't started. When I manually started it, it worked just fine.

So, check to see if the SQL Server service is actually running.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Dhruva_51 SSChampion Points: 10521 More actions · Answer 6

services were running fine. Will look into pushing updates.