Microsoft KB Archive/238309

= BUG: Rebuild Master Fails When Setup Cannot Connect to SQL Server =

Article ID: 238309

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q238309



BUG #: 17330 (SQLBUG_65)



SYMPTOMS
On a SQL Server 6.5 server that is configured to listen on the NWLink IPX/SPX network library, rebuild master may fail with the following error:

The master database could not be successfully rebuilt. Setup could not connect to the SQL Server.

After getting the error, SQL Server may fail to start. The following entry is logged in the errorlog:

97/06/27 09:17:26.35 spid1   server is unnamed 97/06/27 09:17:26.37 spid1   Error: 3405, Severity: 10, State: 3 97/06/27 09:17:26.37 spid1   Recovery dbid 3 ckpt (131,18) oldest = tran=3D(131,0) 97/06/27 09:17:26.37 spid1   Clearing temp db 97/06/27 09:17:26.37 spid1    Error: 941, Severity: 14, State: 1 97/06/27 09:17:26.37 kernel  Failed to create temp db



WORKAROUND
Remove NWLink IPX/SPX network support by running the SQL Setup and selecting "Change Network support". Rebuild the master database, then enable IPX/SPX support.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5.

Keywords: kbbug kbpending KB238309

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.