BUG: Rebuild Master Fails When Setup Cannot Connect to SQL Server (238309)



The information in this article applies to:

  • Microsoft SQL Server 6.5

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.

Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB238309