SQL Server Error #17824

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

It sounds like you are a SQL Server/NT expert, so maybe you can help. We have developed a client/server application using a 3-tier architecture. All has been fine until we started testing with multiple, concurrent users. One error that keeps on creeping up is error # 17824 "unable to write to ListonOn connection loginname 'xxx', hostname 'xxx'. I have not been successful in trying to find a solution on the SQL Server side, maybe a configuration option to change. I have several SQL Server books, but they are vague on the fine tuning. Or our problem may be in the tier that is connecting to SQL Server. This tier is using Remote Data Module servers written in Delphi 3.0 that uses SQL Links 4.5 and Windows NT DCOM for the communication to the SQL Server. Do you have any experience in this area or are you familiar with error #17824 and what to do to prevent or fix it? Any help is appreciated. Thanks. Linda

-- Anonymous, September 20, 1998


Re: SQL Server Error #17824


You will probably find an explanation and/or solution in Microsoft Knowledge Base article Q165158, "INF: How to Troubleshoot Communication Error 17824" at http://support.microsoft.com/support/kb/articles/q165/1/58.asp. (You may be asked to register when accessing this URL. If you need to access other Microsoft Knowledge Base articles you can start at support.microsoft.com.)


-- Anonymous, September 21, 1998

Moderation questions? read the FAQ