BUG: SQL Server 6.5 Upgrade to SQL Server 2000 May Fail When "Preparing sql-dmo for upgrade" Because Path is not in 8.3 Format (291587)



The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)

This article was previously published under Q291587
BUG #:352641 (SHILOH_BUGS)

SYMPTOMS

A two computer database upgrade from Microsoft SQL Server 6.5 to Microsoft SQL Server 2000 fails during the "preparing sql-dmo for upgrade" stage. However, no error message is generated.

CAUSE

The upgrade fails because the path in which SQL Server 2000 is installed is not in the 8.3 format.

WORKAROUND

Install SQL Server in a directory compliant with the 8.3 format. For example, D:\Mssql8.

The upgrade then works successfully.

STATUS

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

MORE INFORMATION

The Preparing sql-dmo for upgrade.out file contains the following:
usage: osql              [-U login id]          [-P password]
  [-S server]            [-H hostname]          [-E trusted connection]
  [-d use database name] [-l login timeout]     [-t query timeout]
  [-h headers]           [-s colseparator]      [-w columnwidth]
  [-a packetsize]        [-e echo input]        [-I Enable Quoted Identifiers]
  [-L list servers]      [-c cmdend]            [-D ODBC DSN name]
  [-q "cmdline query"]   [-Q "cmdline query" and exit]
  [-n remove numbering]  [-m errorlevel]
  [-r msgs to stderr]    [-V severitylevel]
  [-i inputfile]         [-o outputfile]
  [-p print statistics]  [-b On error batch abort]
  [-O use Old ISQL behavior disables the following]
      <EOF> batch processing
      Auto console width scaling
      Wide messages
      default errorlevel is -1 vs 1
  [-? show syntax summary]
				
The upgrade process was running the following command when it failed:
"c:\Program Files\Microsoft SQL Server\80\Tools\binn\osql" -d master -S 
L1QCG923 -V17 -i d:\program  files\microsoft sql 
server\mssql\upgrade\hotfix.sql -Usa "-P" -v 1252.
				
The following registry entry controls the 8.3 format in Microsoft Windows 2000 and Microsoft Windows NT 4.0:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystemNtfsDisable8dot3NameCreation

A value of 1 indicates that 8.3 file format is disabled.

Modification Type:MinorLast Reviewed:11/16/2004
Keywords:kbbug kbpending KB291587