Results 1 to 15 of 15
  1. #1
    Join Date
    Mar 2012
    Posts
    4

    Unanswered: SQL Server 2000 Installation Fail

    I have some old Industrial Real Time Application that uses SQL Server 2000 Server, I am trying to install it but failing, here is the scenario

    Windows 2003 server with and without SP1
    System Model DELL 980Optiplex Core i5
    SQL Server 2000 Enterprise Edition

    during installation it quit instalation with following error "Setup failed to configure the server:

    I have tried my best to resolve the issue but all in vain, I have changed the PC name in all Capitcal words, configre the processor settings in MSCONfig to use one Processor etc but no solution till now,
    I would be very gratefull if somebody help me in this regards

    10:35:45 NetworkLibs = 255
    10:35:45 TCPPort = 1433
    10:35:45 TCPPrxy = Default
    10:35:45 NMPPipeName = \\.\pipe\sql\query
    10:35:45 Result = 1
    10:35:45 End Action DlgNetwork
    10:35:45 begin ShowDialogsUpdateMask
    10:35:45 nFullMask = 0x1bdc00f7, nCurrent = 0x2000000, nDirection = 1
    10:35:45 Updated Dialog Mask: 0x1bdc00f7, Disable Back = 0x1
    10:35:58 SQLProg\SQLServr
    10:35:58 SQLProg\SQLServr\Help
    10:35:58 SQLProg\SQLServr\SCMDev
    10:35:58 SQLProg\SQLServr\SCMDev\SCMh
    10:35:58 SQLProg\SQLServr\SCMDev\SCMX86Lb
    10:35:58 SQLProg\SQLServr\SCMDev\SCMALb
    10:35:58 SQLProg\SQLServr\Rs1033
    10:35:58 SQLProg\SQLServr\RsIntl
    10:35:58 SQLProg\SQLServr\ActiveX
    10:35:58 SQLProg\SQLServr\System
    10:35:58 SQLProg\UpgTools
    10:35:58 SQLProg\UpgTools\UpgSys
    10:35:58 SQLProg\UpgTools\ActiveX
    10:35:58 SQLProg\UpgTools\Res1033
    10:35:58 SQLProg\UpgTools\ResOther
    10:35:58 SQLProg\UpgTools\Resld
    10:35:58 SQLProg\ReplSupp
    10:35:58 SQLProg\ReplSupp\ReplDat
    10:35:58 SQLProg\ReplSupp\RepComm
    10:35:58 SQLProg\ReplSupp\RepNoDk
    10:35:58 SQLProg\ReplSupp\ActiveX
    10:35:58 SQLProg\Install
    10:35:58 SQLProg\System
    10:35:58 SQLProg\SvrExt
    10:35:58 SQLProg\SvrExt\Help
    10:35:58 SQLProg\SvrExt\SvrExtRs
    10:35:58 SQLProg\SvrExt\ResIntl
    10:35:58 SQLProg\Dat
    10:35:58 SQLProg\DatSmpl
    10:35:58 SQLProg\BaseSys
    10:35:58 SQLProg\BaseBinn
    10:35:58 SQLProg\MSSearch
    10:35:58 SQLProg\MSSearch\Help
    10:35:58 SQLProg\MSSearch\ActiveX
    10:35:58 SQLProg\BaseInst
    10:35:58 SQLProg\Symbols
    10:35:58 SQLProg\Symbols\EXE
    10:35:58 SQLProg\Symbols\DLL
    10:35:58 SQLProg\Perfmon
    10:35:58 SQLProg\Perfmon\System
    10:35:58 SQLProg\Root
    10:35:58 MgtTool
    10:35:58 MgtTool\SEM
    10:35:58 MgtTool\SEM\HTML
    10:35:58 MgtTool\SEM\MSD98
    10:35:58 MgtTool\SEM\MSD98SYS
    10:35:58 MgtTool\SEM\MSD98Res
    10:35:58 MgtTool\SEM\MSD98Hlp
    10:35:58 MgtTool\SEM\Help
    10:35:58 MgtTool\SEM\Res1033
    10:35:58 MgtTool\SEM\ResIntl
    10:35:58 MgtTool\SEM\MSD98RsI
    10:35:58 MgtTool\SEM\ActiveX
    10:35:58 MgtTool\SEM\ActiveX\Res1033
    10:35:58 MgtTool\SEM\ActiveX\ResIntl
    10:35:58 MgtTool\SEM\Scripts
    10:35:58 MgtTool\SEM\OLEDB
    10:35:58 MgtTool\SEM\OLEDB\Res1033
    10:35:58 MgtTool\SEM\OLEDB\ResIntl
    10:35:58 MgtTool\Profiler
    10:35:58 MgtTool\Profiler\Help
    10:35:58 MgtTool\Profiler\Res1033
    10:35:58 MgtTool\Profiler\ResIntl
    10:35:58 MgtTool\Qryanlz
    10:35:58 MgtTool\Qryanlz\Help
    10:35:58 MgtTool\Qryanlz\Res1033
    10:35:58 MgtTool\Qryanlz\ResIntl
    10:35:58 MgtTool\DTCCLi
    10:35:58 MgtTool\Wzcnflct
    10:35:58 MgtTool\Wzcnflct\WzcnHlp
    10:35:58 MgtTool\Wzcnflct\Wzcn1033
    10:35:58 MgtTool\Wzcnflct\WzcnOthr
    10:35:58 MgtTool\Wzcnflct\WzcnCmn
    10:35:58 MgtTool\UtilSys
    10:35:58 MgtTool\UtilBinn
    10:35:58 Connect
    10:35:58 Connect\ConnSys
    10:35:58 Books
    10:35:58 Books\Bookso
    10:35:58 Books\Bookso\Utils
    10:35:58 DevTools
    10:35:58 DevTools\Dbg Int
    10:35:58 DevTools\Dbg Int\Dbg Int Common
    10:35:58 DevTools\Dbg Int\EXE
    10:35:58 CoreRepl
    10:35:58 CoreRepl\Res1033
    10:35:58 CoreRepl\ResIntl
    10:35:58 Core
    10:35:58 Core\Res1033
    10:35:58 Core\ResOther
    10:35:58 Repostry
    10:35:58 Repostry\RepstSys
    10:35:58 Repostry\Res1033
    10:35:58 Repostry\ResIntl
    10:35:58 CoreMisc
    10:35:58 CoreMisc\ActiveX
    10:35:58 CoreMisc\ActiveX\Res1033
    10:35:58 CoreMisc\ActiveX\ResIntl
    10:35:58 CoreMisc\Res1033
    10:35:58 Monarch
    10:35:58 Monarch\Monr1033
    10:35:58 Monarch\MonrIntl
    10:35:58 Jet
    10:35:58 CoreInst
    10:35:58 CoreCOM
    10:35:58 CoreCOM\Res1033
    10:35:58 CoreCOM\ResIntl
    10:35:58 CoreTool
    10:35:58 CoreTool\Res1033
    10:35:58 CoreTool\ResOther
    10:35:58 DBLibCli
    10:35:58 SFExt
    10:35:58 SFExt\ActiveX
    10:35:58 SFExt\ActiveX\Res1033
    10:35:58 SFExt\ActiveX\ResIntl
    10:35:58 SFExt\Res1033
    10:35:58 SFExt\ResIntl
    10:35:58 Trace
    10:35:58 Trace\Res1033
    10:35:58 Trace\ResOther
    10:35:58 MiscCore
    10:35:58 MC
    10:35:58 MC\MC1033
    10:35:58 MC\MCIntl
    10:35:58 MC\Help
    10:35:58 SQLMgr
    10:35:58 SQLMgr\Res1033
    10:35:58 SQLMgr\ResIntl
    10:35:58 SvrTool
    10:35:58 SvrTool\Res1033
    10:35:58 SvrTool\ResIntl
    10:35:58 DTSUI
    10:35:58 DTSUI\Res1033
    10:35:58 DTSUI\ResIntl
    10:35:58 MSOlap
    10:35:58 MSOlap\Res1033
    10:35:58 MSOlap\ResIntl
    10:35:58 ATL
    10:35:58 ATL\winnt
    10:35:58 ATL\win9x
    10:35:58 MFC42U
    10:35:58 VC
    10:35:58 VB
    10:35:58 OCX1
    10:35:58 SQLAdHlp
    10:35:58 SQLAdHlp\Res1033
    10:35:58 SQLAdHlp\ResOther
    10:35:58 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
    10:35:58 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
    10:35:58 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
    10:35:58 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
    10:35:58 End Action LogSelectedComponents
    10:35:58 Begin Action InstallPkgs:
    10:35:58 Begin Action: Locked Connectivity Files Check
    10:35:58 ConnectivityLocked returned: 0
    10:35:58 The operation completed successfully.

    10:35:58 End Action: Locked Connectivity Files Check
    10:35:58 Setup is installing Microsoft Data Access Components (MDAC) ...
    10:35:58 E:\SQL Server 2000 Enterprise Edition\X86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
    10:36:05 ExitCode: 0
    10:36:05 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
    10:36:05 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\cl dtcstp.exe -SupportDir "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\B in" -DTCPkg "E:\SQL Server 2000 Enterprise Edition\X86\Other\dtcsetup.exe" -LogFile "C:\WINDOWS\sqlstp.log"
    10:36:05 Process Exit Code: (0)
    10:36:05 InstallMSSearch instance: MSSQLSERVER
    10:36:05 Software\Microsoft\Search\Install:Version not present
    10:36:05 MSSearch 2.0 or greater version check returned -1
    10:36:05 Setup is installing the Microsoft Full-Text Search Engine ...
    10:36:05 "E:\SQL Server 2000 Enterprise Edition\X86\FullText\MSSearch\Search\SearchStp.exe " /s /aQLServer
    10:36:11 Process Exit Code: (0)
    10:36:11 /Q:A /T:C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\ixp001.tmp
    10:36:11 Setup is installing HTML Help ...
    10:36:11 HTML Help installer exit code: 0
    10:36:32 End Action InstallPkgs
    10:36:32 Begin Action MoveFileData:
    10:36:32 Enabled SELFREGISTERBATCH
    10:36:32 Enabled CORECOMPONENTHANDLING
    10:36:38 Begin Action: MoveFileDataSpecial
    10:36:38 End Action: MoveFileDataSpecial
    10:36:38 End Action MoveFileData
    10:36:38 Begin Action ProcessAfterDataMove:
    10:36:38 E:\SQLSER~1\X86\Binn\hhcol.exe C:\Program Files\Microsoft SQL Server\80\Tools\Books
    10:36:39 End Action ProcessAfterDataMove
    10:36:39 Begin Action BuildServer:
    10:36:39 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1 -Action 5 -ExePath "d:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
    10:36:39 Process Exit Code: (0)
    10:36:39 Begin Action: CreateRegistrySetSQL
    10:36:39 End Action: CreateRegistrySetSQL
    10:36:39 Begin Action: RegWriteSetupEntry
    10:36:39 End Action: RegWriteSetupEntry
    10:36:39 Begin Action: CreateSer
    10:36:39 End Action: CreateSer
    10:36:39 Begin Action: SkuIt
    10:36:39 End Action: SkuIt
    10:36:39 SetFileSecuritySQLAndAdmin for d:\Program Files\Microsoft SQL Server\MSSQL returned: 0, 0
    10:36:39 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
    10:36:39 Begin Action: UpdateSystemPath
    10:36:39 Path successfully updated.
    10:36:39 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
    10:36:39 End Action: UpdateSystemPath
    10:36:40 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 327944 -U sa -P
    10:36:42 Process Exit Code: (-1073741819)
    10:36:47 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.
    10:36:47 Action CleanUpInstall:
    10:36:47 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
    10:36:47 Process Exit Code: (1060) The specified service does not exist as an installed service.

    10:36:47 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1 -Action 4 -Service MSSQLSERVER
    10:36:47 Process Exit Code: (0)
    10:36:47 StatsGenerate returned: 2
    10:36:47 StatsGenerate (0x0,0x1,0xf00,0x100,1033,303,0x0,0x1,0,0,0
    10:36:47 StatsGenerate -1,Administrator)
    10:36:47 Installation Failed.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    This article applies to MSDE installs, but it is possible that it could apply to Enterprise Edition, as well. See if clearing out the Data folder helps at all.

    PRB: "Setup Failed to Configure the Server" Error Message When You Install MSDE

    Another possible candidate, if I recall, the datafiles on the CD are set to read-only. If clearing the data directory does not help, try copying the contents of the CD to the local computer (a few hundred MB of space required), set the datafiles (master.mdf, mastlog.ldf, msdbdata.mdf, msdblog.ldf, etc.) to read-write, and see if that does any better.

  3. #3
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    I am amazed you could get the installation of MSSQL 2000 on Windows 2003 server that far.

    I once tried to install MSSQL 2000 on Windows XP. The setup program stopped quickly with an error message: "Your current operating system version is not validated for this version of SQL Server" or something like that.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Windows 2003 is perfectly valid for SQL 2000. Windows XP will refuse any server components, unless it is Developer or MSDE version.

  5. #5
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    On what more recent versions of Windows (server or not) than Windows 2000 server can SQL Server 2000 be installed?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I do not think it can be installed on Windows 2008, but I have not tried. I remember there is a warning on Windows 2003 that you need a service pack (I think SP3) to be in a supportable mode.

  7. #7
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Thanks.

    We are looking for a way to give access to MSSQL 2000 DTS-packages to the external developers without allowing them access to our production environment. The VB-scripts are unreadable, it would be better if they could see the DTS's in the GUI environment.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  9. #9
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Pat, thank you!

    Installing Design-time Support for DTS Packages

    SQL Server 2008 does not install design-time support for DTS packages. Before you can use the SQL Server 2008 tools to open and view DTS packages, you have to download and install this design-time support as described in the following procedure.
    Just what we needed!
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  10. #10
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I kinda figured that this might be a smidgeon easier to install/handle/manage/etc. While you can do ugly things to install SQL 2000, this is a tiny bit tricky but it is well supported, easy to manage, easy to secure, and it doesn't break other toys.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  11. #11
    Join Date
    Mar 2012
    Posts
    4

    SQL Server 2000 Fail to configure the server

    Still I did not receive any solution, I am just installing on fresh installation of Windows 2003 Server, there is no any Antivirus, I have tried on many other machines, when i comes on configuring it exit with error.
    Pls help me and suggest me any technically solution, I am very upset regarding this

  12. #12
    Join Date
    Mar 2012
    Posts
    4

    SQL Server 2000 Installation issue

    Quote Originally Posted by MCrowley View Post
    This article applies to MSDE installs, but it is possible that it could apply to Enterprise Edition, as well. See if clearing out the Data folder helps at all.

    PRB: "Setup Failed to Configure the Server" Error Message When You Install MSDE

    Another possible candidate, if I recall, the datafiles on the CD are set to read-only. If clearing the data directory does not help, try copying the contents of the CD to the local computer (a few hundred MB of space required), set the datafiles (master.mdf, mastlog.ldf, msdbdata.mdf, msdblog.ldf, etc.) to read-write, and see if that does any better.
    I am intalling SQL Server 2000 on fresh instalation of Windows 2003 server, it was same error message, later on i have removed all entries of SQL Server from from installed programes and from registery but same error message is, pls suggest me any soltuion, im really upset.

  13. #13
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Did you try copying the installation files to the server itself?

  14. #14
    Join Date
    Mar 2012
    Posts
    4

    SQL Server 2000 Installation Fail

    Ya, I have copied all CDs on the HDD of my server, I think its the issue of Core i5 Processors...?

  15. #15
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Is there any errorlog file in the log directory of the SQL Server instance? I think the configuration of the instance comes after the first start of the service. If the service can not start, that would be one place to look. Also, are there any interesting events in the System or Application event logs during the install?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •