BUG: xp_sendmail Causes 17969 Error (151562)


The information in this article applies to:

  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
This article was previously published under Q151562
BUG#: 15258

SYMPTOMS

If xp_sendmail is used with the @query parameter and the SQL Server is not listening on the default named pipe "\\.\pipe\sql\query" the following error will occur:
Msg 17969, Level 16, State 1
Unable to login to SQL Server

WORKAROUND

Run SQL Setup to change the named pipe that SQL Server is listening on to the default.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5.
Modification Type:MinorLast Reviewed:2/14/2005
Keywords:kbBug kbProgramming KB151562
©2004 Microsoft Corporation. All rights reserved.