SQL Server 2008 R2 SP3 intermittent can't connect to server

Question

SQL Server 2008 R2 SP3 intermittent can't connect to server

victormeidy

SSC Rookie

Points: 42
More actions
September 30, 2018 at 7:31 pm

#408576

Hi,
Anyone please help me with this some weird issue, so i have SQL server 2008 R2 SP3, which these 3 days always occurs below error while i'm trying to connected via SSMS from remote computer / local.
" A severe error occurred on the current command. The results, if any, should be discarded. "
I'am suspecting this error occurs when i'am connected one of the client PC (Just turn on and connected to the LAN cable without open any programs) but it's occurs intermittent, and connection to the SQL server is good (i'm using PING command).
Please someone hep me with this issue.

Viewing 3 posts - 1 through 3 (of 3 total)

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

Sue_H SSC Guru Points: 90860 More actions · Answer 1

victormeidy - Sunday, September 30, 2018 7:31 PM
Hi,
Anyone please help me with this some weird issue, so i have SQL server 2008 R2 SP3, which these 3 days always occurs below error while i'm trying to connected via SSMS from remote computer / local.
" A severe error occurred on the current command. The results, if any, should be discarded. "
I'am suspecting this error occurs when i'am connected one of the client PC (Just turn on and connected to the LAN cable without open any programs) but it's occurs intermittent, and connection to the SQL server is good (i'm using PING command).
Please someone hep me with this issue.

Have you checked the SQL Server error log and the Windows event logs? One or both should have more information and you may want to check for any dump files (.mdmp or .dmp)

Sue

Jeff Moden SSC Guru Points: 1004642 More actions · Answer 2

I'm thinking that the TCPIP address changed. Try connecting using the instance name instead of the TCPIP address.

--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)