Microsoft KB Archive/163452

From BetaArchive Wiki
Knowledge Base


FIX: Failed RPC Call from SQL Server Generates Error 18481

Article ID: 163452

Article Last Modified on 10/3/2003



APPLIES TO

  • Microsoft SQL Server 6.5 Standard Edition



This article was previously published under Q163452

BUG #: 16506 (Windows: 6.5)

SYMPTOMS

When you make a remote procedure call (RPC) to a SQL Server that does not exist or is not started, you receive the following error message:

Msg 18481, Level 9, State 2
Unable to connect to site 'MyServer' because it is unavailable or does
not exist.


The process terminates the remainder of the batch, but only returns a severity of 9. DB-Library considers severity levels 0 to 10 as informational, and does not cause functions like dbsqlexec, dbrpcexec, and dbsqlok to return FAIL, but rather SUCCEED.

WORKAROUND

To work around this problem, trap for errors 18481 through 18485 in your SQL Server message handler, and handle them appropriately.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.


Additional query words: counter sequence random timestamp generating

Keywords: kbbug kbfix kbusage KB163452