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

ID: Q238309

The information in this article applies to:

Microsoft SQL Server version 6.5

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 version 6.5.

Additional query words:

Keywords : SSrvInst kbbug6.50 kbSQLServ650bug
Version : winnt:6.5
Platform : winnt
Issue type : kbbug