June 16, 2010 at 3:42 am
Hi,
While trying to log into the sql server 2000 its giving the error message "odbc sql server driver shared memory general network error.check your network documentation". is any other way loginto the server similar like DAC ?
Then verify the log file of sql server and found the following error messages
2010-06-16 00:51:46.66 server Error: 17883, Severity: 1, State: 0
2010-06-16 00:51:46.66 server Process 62:0 (fac) UMS Context 0x002ABDA0 appears to be non-yielding on Scheduler 0.
please update your comments to resovle and find root cause of this issue.
SQL Server : 2000
Service Pack : 4
Thanks in Advance.
June 16, 2010 at 7:08 pm
This MS article has information related to this error: http://support.microsoft.com/kb/319892/%5B/url%5D
There are also references to the security patch, but if you have SP 4 , so you should be fine.
Check MiniDump file (SQLDmpr%%%.mdmp) in the LOG folder for more information. Also check if any of SQL Server folders compressed.
June 16, 2010 at 7:20 pm
Try also to change network protocols order for the SQL Client. Set TCP to be top protocol.
June 17, 2010 at 2:15 am
magasvs (6/16/2010)
This MS article has information related to this error: http://support.microsoft.com/kb/319892/%5B/url%5DThere are also references to the security patch, but if you have SP 4 , so you should be fine.
Check MiniDump file (SQLDmpr%%%.mdmp) in the LOG folder for more information. Also check if any of SQL Server folders compressed.
Thanks for your reply.
we have applied latest service pack 4 on server but i still we have that issue. how can i open the .mdmp file ? i tried but i could not.
June 17, 2010 at 6:42 am
You can open SQLDump00NN.txt file in the same folder.
Is this the new SQL Server instance or you used it before? Were you able to connected to the SQL Server before?
June 17, 2010 at 9:34 am
magasvs (6/17/2010)
You can open SQLDump00NN.txt file in the same folder.Is this the new SQL Server instance or you used it before? Were you able to connected to the SQL Server before?
Its there in name of sqldumpXXX.txt. its old one and not able to connect at the time of this issue.
Do you mean to say that both ( .txt and .mdmp) are similar ?
June 17, 2010 at 10:55 am
If the files are old then they will not have information related to your issue. The .mdmp file is more for the Microsoft support and not really readable, but .txt file can have usfull information in case of critical system errors.
So, have you checked disk compression settings for the SQL folders?
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply