SQL2K install fails with folder name sqlexe



Hello all,

I am puzzling over an issue with SQL 2000 install on Windows 2000. I have
tried various versions of both SQL 2000 and Windows 2000 (different SP's).
The install fails when you choose to put the executables on the folder named
C:\sqlexe or another drive letter with that folder name. I figured out today
though that the install works fine if you specify the folder name in mixed
case, i.e. C:\SQLExe. I found that the failure occurs if the folder name is
longer (other characters are added). Here's the location in the sqlstp.log
file where it fails:

4:44:30 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F
"C:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
"SQL_Latin1_General_CP850_BIN" -H 65712 -U sa -P
###############################################################################


Starting Service ...

SQL_Latin1_General_CP850_BIN

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=SAPTS2;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist
or access denied.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=SAPTS2;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist
or access denied.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=SAPTS2;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist
or access denied.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

SQL Server configuration failed.

###############################################################################

14:46:32 Process Exit Code: (-1)

I have a workaround, but looking for why this unusual failure. Thanks!
.



Relevant Pages

  • Re: Problems after SBS_SP1
    ... I followed your steps below, uninstalled monitoring, uninstalled SQL ... I began install monitoring and sharepoint. ... and then locate and rename the following folder: ...
    (microsoft.public.windows.server.sbs)
  • Error installing (KB 921896) SQL Server 2005 -vista-notebook/ act
    ... Tried to download vista service pack auto update for SQL 2005, 56 meg, did ... Try auto starting any SQL SERVICES in SERVICES folder, ... since it will not show any updates after this install. ... If you receive Windows Update error 80070002 while checking for updates, ...
    (microsoft.public.windowsupdate)
  • Re: Reinstalling MSDE 2000 fails (MDAC?)
    ... can I patch setup for using this new hotfix? ... > if named then ..\Program Files\Microsoft SQL Server\MSSQL$InstanceName ... > delete this folder ... > Since you tried to reinstall, you will also find the attempt to install in ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 Beta 2 installation Error-Failed to load SQLSpars.
    ... You will get a better response at the SQL Express newsgroups. ... > I'm trying to install SQL 2K5 Express Edition and got the following error on install. ... but had to abort...(Failed to load SQLSpars.dll) ... > installation files to the folder. ...
    (microsoft.public.sqlserver.setup)
  • Re: sql2005 sp2 does not install: Unable to install Windows Installer MSI file
    ... Hotfix.exe from the folder to start SQL 2005 SP2 setup process. ... install and then try to install SQL 2005 SP2 again ... For a complete list of Microsoft Product Support Services phone numbers, ...
    (microsoft.public.sqlserver.setup)