Microsoft KB Archive/291587

= BUG: SQL Server 6.5 Upgrade to SQL Server 2000 May Fail When &quot;Preparing sql-dmo for upgrade&quot; Because Path is not in 8.3 Format =

Article ID: 291587

Article Last Modified on 11/16/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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 &quot;preparing sql-dmo for upgrade&quot; 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 &quot;cmdline query&quot;]  [-Q &quot;cmdline query&quot; 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]  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: &quot;c:\Program Files\Microsoft SQL Server\80\Tools\binn\osql&quot; -d master -S L1QCG923 -V17 -i d:\program files\microsoft sql server\mssql\upgrade\hotfix.sql -Usa &quot;-P&quot; -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.

Keywords: kbbug kbpending KB291587

-

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

© Microsoft Corporation. All rights reserved.