April 1, 2011 at 12:23 pm
hi all,
we are having a test server from which a production server is linked using linked server. i am facing a strange problem from today morning. i was able to connect to the test server instance i executed a query which was calling the database in production server, the query went on for a while. i have tried to open the another instance of the server in SSMS but i have encountered timeout expired. i have cancelled the query which i have executed first. then from that time i am not able to connect to my test server instance at all. i did not get the reason? i found a couple of error repeating in application log 17883 error,17884 error. have any of you guys faced such a problem.
April 1, 2011 at 2:14 pm
17883 errors are usual UMS scheduler hung. There is one UMS Scheduler per CPU. If they are all hung SQL will be unresponsive.
You could try getting in using the DAC and trying to kill any processes running but in all likliehood you are going to have to stop and restart the instance.
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply