Failed to install SQL Server 7 on Windows XP Home

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Failed to install SQL Server 7 on Windows XP Home

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-14 : 08:43:00

Andy writes "I'm trying to install SQL Server 7 on Windows XP Home edition, but failed. I got a message "Setup failed to configure the server."

Can I install SQL 7 on XP Home? If I can, what could be the problem? Thanks for your help."

penumatsa
Constraint Violating Yak Guru

289 Posts

Posted - 2002-01-14 : 08:49:39

What edition of SQL Server 7 were you trying to install?

suresh penumatsa

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-14 : 12:56:50

You can install the destop edition. Since you got that message, I am assuming that is the edition you were trying to install, otherwise you would have gotten the '...only client tools will be available...' message.

Look in the cnfgsvr.out and sqlstp.log files

They should provide an error, or at least more of a clue as to why the failure occured. Post the error, mayme we can help.

-Chad

andyww32
Starting Member

9 Posts

Posted - 2002-01-14 : 22:47:57

Thanks for the response.

I was installing SQL 7 desktop edition. Actually I had another error during the installation. When asked to set up Service Account, I first used the second option under Service Settings. That's my login user name and password. I got the following error:

"The lonon account cannot be validated for the SQL Server Service. Verify that the user name and password entered are correct. The Logon attempt failed."

Then I checked my Control Panel -> Services. I couldn't find SQLService there. Maybe this is the problem? Does XP have SQLService pre-installed? Or I have to install it by myself? If I have to do it, where can I get SQLservice for XP?

And here is the log:
*****************************
2002-01-09 00:15:59.46 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: )

2002-01-09 00:15:59.50 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2002-01-09 00:15:59.50 kernel All rights reserved.
2002-01-09 00:15:59.50 kernel Logging SQL Server messages in file 'C:\MSSQL7\log\ERRORLOG'.
2002-01-09 00:15:59.57 kernel initconfig: Number of user connections limited to 32767.
2002-01-09 00:15:59.57 kernel SQL Server is starting at priority class 'normal'(1 CPU detected).
2002-01-09 00:15:59.62 kernel User Mode Scheduler configured for thread processing
2002-01-09 00:16:00.76 server Directory Size: 21607
2002-01-09 00:16:00.81 spid1 Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
2002-01-09 00:16:00.83 spid1 Warning ******************
2002-01-09 00:16:00.83 spid1 SQL Server started in single user mode. Updates allowed to system catalogs.
2002-01-09 00:16:00.83 spid1 Warning ******************
2002-01-09 00:16:00.83 spid1 Recovering only master database
2002-01-09 00:16:00.83 spid1 Starting up database 'master'.
2002-01-09 00:16:00.83 spid1 Opening file C:\MSSQL7\data\master.mdf.
2002-01-09 00:16:00.94 spid1 Opening file C:\MSSQL7\data\mastlog.ldf.
2002-01-09 00:16:01.04 spid1 Loading SQL Server's Unicode collation.
2002-01-09 00:16:01.09 spid1 Loading SQL Server's non-Unicode sort order and character set.
2002-01-09 00:16:01.19 spid1 4 transactions rolled forward in database 'master' (1).
2002-01-09 00:16:01.21 spid1 0 transactions rolled back in database 'master' (1).
2002-01-09 00:16:01.48 spid1 Server is unnamed.
2002-01-09 00:16:01.48 kernel Using 'SQLEVN70.DLL' version '7.00.623'.
2002-01-09 00:16:01.48 kernel Using 'OPENDS60.DLL' version '7.00.00.0623'.
2002-01-09 00:16:01.51 ods Using 'SSNMPN70.DLL' version '7.0.623' to listen on '\\.\pipe\sql\query'.
2002-01-09 00:16:01.51 ods Using 'SSMSSO70.DLL' version '7.0.623' to listen on '1433'.
2002-01-09 00:16:01.86 ods Using 'SSMSRP70.DLL' version '7.0.623' to listen on 'DD2'.
2002-01-09 00:16:01.93 spid1 SQL Server's Unicode collation is:
2002-01-09 00:16:01.93 spid1 'English' (ID = 1033).
2002-01-09 00:16:01.93 spid1 comparison style = 196609.
2002-01-09 00:16:01.93 spid1 SQL Server's non-Unicode sort order is:
2002-01-09 00:16:01.93 spid1 'nocase_iso' (ID = 52).
2002-01-09 00:16:01.93 spid1 SQL Server's non-Unicode character set is:
2002-01-09 00:16:01.94 spid1 'iso_1' (ID = 1).
2002-01-09 00:16:01.96 kernel Warning: override, autoexec procedures skipped.
2002-01-09 00:18:35.02 kernel SQL Server is terminating due to 'stop' request from Service Control Manager.
************************

quote:

You can install the destop edition. Since you got that message, I am assuming that is the edition you were trying to install, otherwise you would have gotten the '...only client tools will be available...' message.

Look in the cnfgsvr.out and sqlstp.log files

They should provide an error, or at least more of a clue as to why the failure occured. Post the error, mayme we can help.

-Chad

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-15 : 11:19:22

That is the problem. You must be entering an incorrect password or something. Try installing it using 'Local System' and then you will find MSSQLServer service after it is installed. Then you can change it to an Admin account.

During configuration of the server, it has to stop and start the services, but if the account has an invalid password, it can't do that, thus it will fail.

HTH
-Chad

andyww32
Starting Member

9 Posts

Posted - 2002-01-15 : 11:46:13

1. I used my login user name, which does not have a password. the domain shows my computer name. But I couldn't make the connection.

2. I did try using "Local system", which allowed me to go on till the last stage of the installation. When it's trying to connect the server, I got the message "Setup failed to configure the server.", which I reported in my first post.

3. When I went to Control Panel and tried to start the service, I couldn't find SQLService. So the question is whether XP has SQLService installed? My XP is pre-installed by the vendor, I don't have a CD.

Thanks,

Andy

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-15 : 11:58:32

No,

The SQL Server Service is what you are trying to install.

Did you find the files I told you about? cnfgsvr.out and sqlstp.log?

Those files will tell what the problem is.

-Chad

andyww32
Starting Member

9 Posts

Posted - 2002-01-15 : 14:01:03

No, I didn't find the two files you mentioned. Is there a specific folder I should look for? The only log I found is the one I posted here.

I guess I'll re-install it tonight. Is there anything from previous failed installation I need to clean up before a new installation?

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-15 : 14:06:40

I believe they are in the WINNT folder, but I can never remember. Just do a search for the filename.

It will likely fail again, because whatever caused the failure hasn't been resolved. I would look in those 2 files first, and post the results.

-Chad

andyww32
Starting Member

9 Posts

Posted - 2002-01-15 : 22:50:13

You're right. The installation failed again. But I was able to find the two files for this installation. cnfgsvr.out is in c:\MSSQL7\Install, and sqlstp.log is in C:\WINDOWS. Here they are:

cnfgsvr.out
*******************

Starting Service ...

Connecting to Server ...

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

[Microsoft][ODBC SQL Server Driver]Timeout expired

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

[Microsoft][ODBC SQL Server Driver]Timeout expired

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

[Microsoft][ODBC SQL Server Driver]Timeout expired

SQL Server configuration failed.
***************************

sqlstp.log
***************************
22:04:53 Begin Setup
22:04:54 7.00.623
22:04:54 Mode=Normal
22:04:54 ModeType=NORMAL
22:04:54 Desktop override enabled.
22:04:54 ValueFTS returned: 0
22:04:54 ValuePID returned: 0
22:04:54 ValueLic returned: 0
22:04:54 GetDefinitionEx returned: 0, Extended: 0x0
22:04:54 System: Windows NT WorkStation
22:04:54 SQL Server ProductType: Developer Edition [0x2]
22:04:54 Begin Action: SetupInitialize
22:04:55 End Action SetupInitialize
22:04:57 Fixed install: 0
22:04:57 Begin Action: CheckRequirements
22:04:57 Platform ID: 0xf000000
22:04:57 Version: 5.1.2600
22:04:57 Processor Architecture: x86 (Pentium)
22:04:57 File Version - C:\WINDOWS\System32\shdocvw.dll: 6.0.2712.300
22:04:57 ComputerName: DD2
22:04:57 User Name: ww
22:04:57 IsAllAccessAllowed returned: 1
22:04:57 OS Language: 0x409
22:04:57 End Action CheckRequirements
22:04:57 Begin Action: Detection
22:04:57 End Action Detection
22:04:57 Begin Action: ODBCLocked
22:04:57 End Action ODBCLocked
22:04:57 This combination of Package and Operating System allows a full product install.
22:04:57 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
22:04:57 CommonFilesDir=C:\Program Files\Common Files
22:04:57 Windows Directory=C:\WINDOWS22:04:57 Begin Action: ShowDialogs
22:04:57 Begin Action: DialogShowSdWelcome
22:04:59 End Action DialogShowSdWelcome
22:04:59 Begin Action: DialogShowSdLicense
22:05:00 End Action DialogShowSdLicense
22:05:00 Begin Action: DialogShowSdRegisterUserEx
22:05:13 End Action DialogShowSdRegisterUserEx
22:05:13 Begin Action: DialogShowSdSetupType
22:05:16 SQL program folder: C:\MSSQL7
22:05:16 SQL data folder: C:\MSSQL7
22:05:16 Windows system folder: C:\WINDOWS\System3222:05:16 Prog req: 82753, Data req: 30597, Sys req: 33392
22:05:16 Prog avail: 2147155, Data avail: 2147155, Sys avail: 2147155
22:05:16 Prog req vs. avail, 146742, 2147155
22:05:16 Data req vs. avail, 30597, 2147155
22:05:16 Sys req vs. avail, 63989, 2147155
22:05:16 DisplaySystemPreReq
22:05:16 [SetupTypeSQL]
22:05:16 szDir=C:\MSSQL7
22:05:16 Result=301
22:05:16 szDataDir=C:\MSSQL7
22:05:16 End Action DialogShowSdSetupType
22:05:16 Begin Action: DialogShowSdComponentMult
22:05:16 End Action DialogShowSdComponentMult
22:05:16 Begin Action: DlgCpSortUnicode
22:05:16 [DlgCpSortUnicode]
22:05:16 SortId=52
22:05:16 LCID=1033
22:05:16 CompStyle=196609
22:05:16 Result=32583256
22:05:16 End Action DlgCpSortUnicode
22:05:16 Begin Action: DlgNetwork
22:05:16 [DlgServerNetwork]
22:05:16 NetworkLibs=4095
22:05:16 TCPPort=1433
22:05:16 TCPPrxy=Default
22:05:16 NMPPipeName=\\.\pipe\sql\query
22:05:16 Result=917920
22:05:16 End Action DlgNetwork
22:05:16 Begin Action: DlgServices
22:05:25 [DlgServices]
22:05:25 Local-Domain=3855
22:05:25 AutoStart=61455
22:05:25 Result=1
22:05:25 End Action DlgServices
22:05:25 Begin Action: DialogShowSdStartCopy
22:05:30 End Action DialogShowSdStartCopy
22:05:30 Begin Action: DlgCPLLicense
22:05:30 End Action DlgCPLLicense
22:05:30 End Action ShowDialogs
22:05:30 Begin Action ProcessBeforeDataMove:
22:05:30 DeinstallStart returned (C:\MSSQL7): 0
22:05:30 End Action ProcessBeforeDataMove:
22:05:30 Begin Action ProcessComponentSelection:
22:05:30 End Action ProcessComponentSelection
22:05:30 Begin Action LogSelectedComponents:
22:05:30 SQLProg
22:05:30 SQLProg\SQLServr
22:05:30 SQLProg\SQLServr\Help
22:05:30 SQLProg\SQLServr\SCMDev
22:05:30 SQLProg\SQLServr\SCMDev\SCMh
22:05:30 SQLProg\SQLServr\SCMDev\SCMX86Lb
22:05:30 SQLProg\SQLServr\SCMDev\SCMALb
22:05:30 SQLProg\UpgTools
22:05:30 SQLProg\UpgTools\UpgSys
22:05:30 SQLProg\ReplSupp
22:05:30 SQLProg\ReplSupp\ReplSys
22:05:30 SQLProg\ReplSupp\ReplDat
22:05:30 SQLProg\ReplSupp\ReplSys1
22:05:30 SQLProg\ReplSupp\RepComm
22:05:30 SQLProg\Install
22:05:30 SQLProg\System
22:05:30 SQLProg\SvrExt
22:05:30 SQLProg\SvrExt\Help
22:05:30 SQLProg\DTS
22:05:30 SQLProg\DTS\Help
22:05:30 SQLProg\DTS\Res1033
22:05:30 SQLProg\DTS\ResIntl
22:05:30 SQLProg\Dat
22:05:30 SQLProg\DatSmpl
22:05:30 SQLProg\BaseSys
22:05:30 SQLProg\BaseBinn
22:05:30 SQLProg\BaseInst
22:05:30 MgtTool
22:05:30 MgtTool\SEM
22:05:30 MgtTool\SEM\HTML
22:05:30 MgtTool\SEM\MSD98
22:05:30 MgtTool\SEM\MSD98SYS
22:05:30 MgtTool\SEM\MSD98Res
22:05:30 MgtTool\SEM\MSD98Hlp
22:05:30 MgtTool\SEM\Help
22:05:30 MgtTool\SEM\SEMSys
22:05:30 MgtTool\SEM\Res1033
22:05:30 MgtTool\SEM\ResIntl
22:05:30 MgtTool\SEM\MSD98RsI
22:05:30 MgtTool\Profiler
22:05:30 MgtTool\Profiler\Help
22:05:30 MgtTool\Profiler\Res1033
22:05:30 MgtTool\Profiler\ResIntl
22:05:30 MgtTool\Qryanlz
22:05:30 MgtTool\Qryanlz\Help
22:05:30 MgtTool\Qryanlz\Res1033
22:05:30 MgtTool\Qryanlz\ResIntl
22:05:30 MgtTool\DTCCLi
22:05:30 MgtTool\Wzcnflct
22:05:30 MgtTool\Wzcnflct\Wzcnsys
22:05:30 MgtTool\Wzcnflct\WzcnHlp
22:05:30 MgtTool\UtilSys
22:05:30 MgtTool\UtilBinn
22:05:30 Connect
22:05:30 Connect\ConnSys
22:05:30 Connect\Conn9x
22:05:30 Connect\ConnNT
22:05:30 Books
22:05:30 Books\Bookso
22:05:30 Books\BooksCD
22:05:31 Core
22:05:31 CoreSys
22:05:31 ODBC
22:05:31 OLEDB
22:05:31 Repostry
22:05:31 RepstSys
22:05:31 CoreMisc
22:05:31 Monarch
22:05:31 Jet
22:05:31 NetCore
22:05:31 NetExt
22:05:31 CoreInst
22:05:31 SFExt
22:05:31 ReplExt
22:05:31 Core1033
22:05:31 CoreIntl
22:05:31 CrMi1033
22:05:31 CrMiIntl
22:05:31 Monr1033
22:05:31 MonrIntl
22:05:31 SFEx1033
22:05:31 SFExIntl
22:05:31 RpEx1033
22:05:31 RpExIntl
22:05:31 SysCore
22:05:31 VOLEDB
22:05:31 VODBC
22:05:31 MiscCore
22:05:31 MCHlp
22:05:31 MC1033
22:05:31 MCIntl
22:05:31 CnctBinn
22:05:31 CrRepCom
22:05:31 {E07FDDC8-5A21-11d2-9DAD-00C04F79D434}
22:05:31 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
22:05:31 End Action LogSelectedComponents
22:05:31 Begin Action MoveFileData:
22:08:53 End Action MoveFileData
22:08:53 Begin Action ProcessAfterDataMove:
22:08:53 DeinstallSetReference (C:\MSSQL7\sqlservr.exe) returned: 0
22:08:53 End Action ProcessAfterDataMove
22:08:53 Begin Action InstallPkgs:
22:08:53 Setup is installing Microsoft Management Console (MMC) ...
22:08:53 D:\x86\Other\instmmc.exe /Q
22:09:21 Process Exit Code: (0)
22:09:21 Setup is installing HTML Help ...
22:09:24 HTML Help installer exit code: 0
22:09:24 End Action InstallPkgs
22:09:24 Begin Action BuildServer:
22:09:24 C:\WINDOWS\TEMP\_ISTMP11.DIR\scm.exe -Silent 1 -Action 5 -ExePath "C:\MSSQL7\binn\sqlservr.exe"
22:09:25 Process Exit Code: (0)
22:09:25 Desktop override enabled.
22:09:25 Path successfully updated.
22:09:25 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\MSSQL7\BINN
22:09:25 C:\MSSQL7\binn\cnfgsvr.exe -Silent 2 -NoSampleDB 0 -SQLPath "C:\MSSQL7\" -SQLDataPath "C:\MSSQL7\" -SortID 52 -LCIDCompStyle "1033-196609" -HWND 917920 -User sa -Pwd
22:12:25 Process Exit Code: (-1)
22:12:52 Setup failed to configure the server. Refer to the server error logs and cnfgsvr.out for more information.
22:12:52 Action CleanUpInstall:
22:12:52 C:\WINDOWS\TEMP\_ISTMP11.DIR\scm.exe -Silent 1 -Action 4 -Service SQLServerAgent
22:12:52 Process Exit Code: (1060) The specified service does not exist as an installed service.

22:12:52 C:\WINDOWS\TEMP\_ISTMP11.DIR\scm.exe -Silent 1 -Action 4 -Service MSSQLServer
22:12:57 Process Exit Code: (0)
22:12:57 Installation Failed.
*********************************

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-16 : 12:16:40

First question,

You are not trying to install over Terminal Services are you?

Second,

Does your machine have a computername? If not, give it one and retry.

-Chad

andyww32
Starting Member

9 Posts

Posted - 2002-01-16 : 14:31:42

1. No, I'm not installing over Terminal Servicers.

2. There is a computername, which is in the log as:

**************************
22:04:57 ComputerName: DD2
**************************

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-16 : 15:02:20

Okay, let's try the following:

1. Copy the contents of the CD to your hard drive.
2. Stop all non-essential services.
3. explicitly add the local system account to the C:\ drive (Full control)
4. run setup in debug mode.
from a command line run setupsql k=Dbg k=Dk

(This will confirm each step before it installs it)

HTH

-Chad

andyww32
Starting Member

9 Posts

Posted - 2002-01-16 : 16:09:49

Please bear with my inexperience, could you give more instruction on Step 3: how to explicitly add the local system account to C:?

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-16 : 16:18:37

Right-Click on the C:\ drive in windows explorer click properties. Go to the security tab, click add, find the System account and add it. Give it full control.

-Chad

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-16 : 16:21:31

I am assuming an NTFS file system. If it is FAT, ignore that step.

Sorry.

-Chad

andyww32
Starting Member

9 Posts

Posted - 2002-01-16 : 23:31:32

It still doesn't work.

1. It is a NTFS (Windows XP, but not NT). But there is not a Security tab in Properties, only a Sharing tab. I added "sa" through XP's User Account Administration, and gave it full control. Then log in as "sa".

2. Used the command line to run set up in debug mode. Did get confirmation at each step. But it failed at the step of configuring the server. (Starting Service... Connecting to Server... Connect failed - Retrying...)

3. The two log files looked as the ones I posted before.

4. I just notice that in the cnfgsvr.out file, it tried three times to make the connection. The first two times, it didn't pick up the server name. but the last time, server name was picked up. Can you explain this?

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-17 : 00:40:29

I am running short on ideas? Do you have any anti-virus software running? If so, stop it before the install.

The only other thing I can suggest is to make sure there are no SQL Server remains in the Registry, then try again. If that doesn't work, you may have to FDisk and reinstall.

WARNING EDITING THE REGISTRY CAN BE DANGEROUS, MAKE A BACKUP BEFORE ATTEMPTING THIS.

1. open regedit
2. go to HKLM->Software->Microsoft->MSSQLServer and delete it if it exists.
3. Delete c:\mssql7 if it exists.

If the install fails after that, You could call MS Support, or try reinstalling the OS.

Sorry, It doesn't seem like there is an easy solution to this one.

-Chad

andyww32
Starting Member

9 Posts

Posted - 2002-01-18 : 09:53:17

Thanks for all the sugestions. I'll report back if I have any luck.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources