Microsoft KB Archive/67330

PRSQL9012021: ISQL Hangs Restoring Master Database ID Number: Q67330

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9012021

SYMPTOMS When loading the master database from a dump, ISQL hangs, and the following error message is received:

DB-Library: Error in sending out-of-band data to SQL Server. CAUSE This problem occurs when using ISQL with network pipes by connecting from a remote workstation or a local machine (for example, “isql /U sa /P /S servername”) to load the master database. ISQL loads the master database correctly and shuts down the SQL Server; however, ISQL appears to hang.

RESOLUTION Connect to the SQL Server using ISQL via a local pipe; for example, “isql /U sa /P”. When this local pipe is used, ISQL exits with the following error message:

DB-Library: Unexpected EOF from SQL Server. This is expected behavior.