SQL Server 2012 Error : "A severe error occurred on the current command."

Hello Experts,
From a last few days in my asp.net - SQL server 2012 application I received error like "A severe error occurred on the current command.".

Before this i received errors "Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached".

I checked my code, but all the connections are closed as soon as their task is over. So, to avoid this error i've start pooling.

Now I am getting above error ("A severe error occurred on the current command.") and after a few minutes error resolved automatically. This is happening frequently.

I have checked with DBCC commands but showing no error. Is there any issue with SQL Server or with coding ?

Thanks in advance
dotsandcomsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Harish VargheseProject LeaderCommented:
First, perform a CHECKDB to look for any consistency issues in database.
You may see similar issue here: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/7c4dd91f-4ca6-4cb9-ad8b-c8f32e9d25e7/a-severe-error-occurred-on-the-current-command-the-results-if-any-should-be-discarded
If you see any issue in CHECKDB, then see this link for remedies: http://www.sql-server-pro.com/dbcc-checkdb.html
0
dotsandcomsAuthor Commented:
Hi,
i did not get any error.

below is the last two lines of result
CHECKDB found 0 allocation errors and 0 consistency errors in database 'd5qst4z'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Open in new window

0
hspoulsenCommented:
To me it sounds like a problem with your IIS server.
There is a Max Pool Size setting that you may need to change, if your server is under heavier use than it used to be.

If the usage is the same as usual, the IIS server may need a re-boot, in order to reclaim pools.

I'm not a ISS expert by any means. I only tell you what used to work for me.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

dotsandcomsAuthor Commented:
hi,
as per suggestion, I have restarted IIS, till now no error occurred.
0
Kamal KhaleefaInformation Security SpecialistCommented:
Hi
I face a similar problem and the problem was some of my functions were not closing the connection
Make sure to add finally try. Catch in each function and to add the connection.close inside the finally
Also check if u have a dead lock in ur code
0
dotsandcomsAuthor Commented:
hi
i am using 3-tier architecture and i am closing all the connections. Also, there isn't any deadlocks. After restarting IIS i didn't receive any error but i want to wait a few more day before accepting solution.
0
dotsandcomsAuthor Commented:
Hi,
I received error again. This time, I am not able login from Management Studio and getting below error :

TITLE: Connect to Server
------------------------------

Cannot connect to <serverIP>.

------------------------------
ADDITIONAL INFORMATION:

A severe error occurred on the current command.  The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Open in new window


I have also ran DBCC commnads (DBCC CHECKALLOC,DBCC CHECKCATALOG,DBCC CHECKDB,DBCC CHECKFILEGROUP) but not found any error in any of the DBCC commands.

Is there any server side issue.
Website hosting and SQL server hosting are on different servers.
0
hspoulsenCommented:
that is not the same type of error ("a servere error occured..."), but a connection error.
Did you check your network?

Best regards,
Henrik
0
dotsandcomsAuthor Commented:
network is ok.

look at "ADDITIONAL INFORMATION" in the message. It says "A Severe error occurred".
0
hspoulsenCommented:
yes, but no "Max pool size".
You may also see a situation where the SQL Server is too busy to allow additional users.

In the old days, I would go down to the SQL Server and check it out.
These days, I would try the "ADMIN:" keyword in the connection string.

See http://technet.microsoft.com/en-us/library/ms178068(v=sql.105).aspx

The busy SQL Server may be caused by lots of different reasons; massive rollback, disk problems, run-a-way SSIS packages, incorrect memory settings...
0
dotsandcomsAuthor Commented:
Hello,
I am not getting errors now. Techsupport has change the memory settings and its working fine.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hspoulsenCommented:
glad it helped.

Best regards,
Henrik
0
dotsandcomsAuthor Commented:
Hello,
now error gone.
0
akash royCommented:
Dear Expert
             
when i put “select * from tblname” then i got error like “Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.”

pls help
0
Anthony PerkinsCommented:
pls help
I would suggest you post your own question, as opposed to piggy-backing  on this 3 year old thread.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.