SQL Server 2000 installation failed

Pusstiu · August 21st, 2007, 08:56 AM

hello,

First i tried to install MSDE, but it didn't work.
Then i tried the SQl Server 2000 and the installation failed. In the error message i was adviced to look at the file sqlstp.log
I'm sending this file to you and i hope somebody can help me.
The content of this file is:
15:21:39 Begin Setup
15:21:39 8.00.194
15:21:39 Mode = Normal
15:21:39 ModeType = NORMAL
15:21:39 GetDefinitionEx returned: 0, Extended: 0x0
15:21:39 ValueFTS returned: 1
15:21:39 ValuePID returned: 1
15:21:39 ValueLic returned: 0
15:21:39 System: Windows NT WorkStation
15:21:39 SQL Server ProductType: Developer Edition [0x3]
15:21:39 Begin Action: SetupInitialize
15:21:39 End Action SetupInitialize
15:21:39 Begin Action: SetupInstall
15:21:39 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
15:21:39 CommonFilesDir=C:\Program Files\Common Files
15:21:39 Windows Directory=C:\WINDOWS15:21:39 Program Files=C:\Program Files15:21:39 TEMPDIR=C:\WINDOWS\TEMP15:21:39 Begin Action: SetupInstall
15:21:39 digpid size : 256
15:21:40 digpid size : 164
15:21:40 Begin Action: CheckFixedRequirements
15:21:40 Platform ID: 0xf000000
15:21:40 Version: 5.1.2600
15:21:40 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.2900.3121
15:21:40 End Action: CheckFixedRequirements
15:21:40 Begin Action: ShowDialogs
15:21:40 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
15:21:40 Begin Action ShowDialogsHlpr: 0x1
15:21:40 Begin Action: DialogShowSdWelcome
15:21:41 End Action DialogShowSdWelcome
15:21:41 Dialog 0x1 returned: 1
15:21:41 End Action ShowDialogsHlpr
15:21:41 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
15:21:41 Begin Action ShowDialogsHlpr: 0x2
15:21:41 Begin Action: DialogShowSdMachineName
15:21:42 ShowDlgMachine returned: 1
15:21:42 Name = SERVER1, Type = 0x1
15:21:42 Begin Action: CheckRequirements
15:21:42 Processor Architecture: x86 (Pentium)
15:21:42 Service Pack: 512
15:21:42 ComputerName: SERVER1
15:21:42 User Name: Administrator
15:21:42 IsAllAccessAllowed returned: 1
15:21:42 OS Language: 0x409
15:21:42 End Action CheckRequirements
15:21:42 This combination of Package and Operating System allows a full product install.
15:21:42 CreateSetupTopology(SERVER1), Handle : 0x1484138, returned : 0
15:21:42 CreateSetupTopology returned : 0, Handle : 0x1484138
15:21:42 Topology Type : 1, Return Value : 0
15:21:42 ST_GetPhysicalNode returned : 0, PNHandle : 0x1484160
15:21:42 PN_EnumerateEx returned : 0
15:21:42 PN_GetSQLStates returned : 0, SqlStates : 0x0
15:21:42 PN_StartScan [0x1484160] returned : 0
15:21:42 PN_GetNext [0x1484160] returned : 18, Handle: [0x0]
15:21:42 No more items in enumeration.
15:21:42 ReleaseSetupTopology
15:21:42 Named instance limit: 100, quota: 0
15:21:42 End Action DialogShowSdMachineName
15:21:42 begin ShowDialogsUpdateMask
15:21:42 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
15:21:42 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
15:21:42 Dialog 0x2 returned: 0
15:21:42 End Action ShowDialogsHlpr
15:21:42 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
15:21:42 Begin Action ShowDialogsHlpr: 0x4
15:21:42 Begin Action: DialogShowSdInstallMode
15:21:47 ShowDlgInstallMode returned: 1
15:21:47 InstallMode : 0x1
15:21:47 End Action DialogShowSdInstallMode
15:21:47 begin ShowDialogsUpdateMask
15:21:47 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
15:21:47 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
15:21:47 Dialog 0x4 returned: 1
15:21:47 End Action ShowDialogsHlpr
15:21:47 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
15:21:47 Begin Action ShowDialogsHlpr: 0x10
15:21:47 Begin Action: DialogShowSdRegisterUserEx
15:21:49 End Action DialogShowSdRegisterUserEx
15:21:49 Dialog 0x10 returned: 1
15:21:49 End Action ShowDialogsHlpr
15:21:49 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
15:21:49 Begin Action ShowDialogsHlpr: 0x20
15:21:49 Begin Action: DialogShowSdLicense
15:21:50 End Action DialogShowSdLicense
15:21:50 Dialog 0x20 returned: 1
15:21:50 End Action ShowDialogsHlpr
15:21:50 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
15:21:50 Begin Action ShowDialogsHlpr: 0x40000
15:21:50 Begin Action: DialogShowSdCliSvr
15:21:50 DisplaySystemPreReq
15:21:52 ShowDlgClientServerSelect returned: 1
15:21:52 Type : 0x2
15:21:52 End Action DialogShowSdCliSvr
15:21:52 begin ShowDialogsUpdateMask
15:21:52 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
15:21:52 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
15:21:52 Dialog 0x40000 returned: 1
15:21:52 End Action ShowDialogsHlpr
15:21:52 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
15:21:52 Begin Action ShowDialogsHlpr: 0x80000
15:21:52 Begin Action: DialogShowSdInstanceName
15:21:52 Begin Action: ShowDlgInstanceName
15:22:01 End Action: ShowDlgInstanceName
15:22:01 ShowDlgInstanceName returned : 1
15:22:01 InstanceName : SQL2000
15:22:01 End Action DialogShowSdInstanceName
15:22:01 begin ShowDialogsUpdateMask
15:22:01 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
15:22:01 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
15:22:01 Dialog 0x80000 returned: 1
15:22:01 End Action ShowDialogsHlpr
15:22:01 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
15:22:01 Begin Action ShowDialogsHlpr: 0x100000
15:22:01 Begin Action: DialogShowSdSetupType
15:22:01 Begin Action: Setup Type
15:22:03 SQL program folder: C:\Program Files\Microsoft SQL Server
15:22:03 SQL data folder: C:\Program Files\Microsoft SQL Server
15:22:03 Windows system folder: C:\WINDOWS\system3215:22:03 Prog req: 34657, Data req: 34432, Sys req: 156897
15:22:03 Prog avail: 25260632, Data avail: 25260632, Sys avail: 25260632
15:22:03 Prog req vs. avail, 225986, 25260632
15:22:03 Data req vs. avail, 34432, 25260632
15:22:03 Sys req vs. avail, 191329, 25260632
15:22:03 DisplaySystemPreReq
15:22:03 [SetupTypeSQL]
15:22:03 szDir = C:\Program Files\Microsoft SQL Server
15:22:03 szDir = %PROGRAMFILES%\Microsoft SQL Server
15:22:03 Result = 301
15:22:03 szDataDir = C:\Program Files\Microsoft SQL Server
15:22:03 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
15:22:03 End Action: Setup Type
15:22:03 Setup Type: Typical (301)
15:22:03 End Action DialogShowSdSetupType
15:22:03 begin ShowDialogsUpdateMask
15:22:03 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
15:22:03 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
15:22:03 Dialog 0x100000 returned: 301
15:22:03 End Action ShowDialogsHlpr
15:22:03 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
15:22:03 Begin Action ShowDialogsHlpr: 0x400000
15:22:03 Begin Action: DlgServices
15:22:08 ShowDlgServices returned: 1
15:22:08 [DlgServices]
15:22:08 Local-Domain = 3855
15:22:08 AutoStart = 15
15:22:08 Result = 1
15:22:08 End Action DlgServices
15:22:08 begin ShowDialogsUpdateMask
15:22:08 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
15:22:08 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
15:22:08 Dialog 0x400000 returned: 1
15:22:08 End Action ShowDialogsHlpr
15:22:08 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
15:22:08 Begin Action ShowDialogsHlpr: 0x800000
15:22:08 Begin Action: DlgSQLSecurity
15:22:29 ShowDlgSQLSecurity returned: 1
15:22:29 LoginMode = 2,szPwd
15:22:29 End Action DlgSQLSecurity
15:22:29 begin ShowDialogsUpdateMask
15:22:29 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
15:22:29 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
15:22:29 Dialog 0x800000 returned: 1
15:22:29 End Action ShowDialogsHlpr
15:22:29 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
15:22:29 Begin Action ShowDialogsHlpr: 0x1000000
15:22:29 Begin Action: DlgCollation
15:22:29 ShowDlgCollation returned: 1
15:22:29 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
15:22:29 End Action DlgCollation
15:22:29 begin ShowDialogsUpdateMask
15:22:29 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
15:22:29 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
15:22:29 Dialog 0x1000000 returned: 1
15:22:29 End Action ShowDialogsHlpr
15:22:29 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
15:22:29 Begin Action ShowDialogsHlpr: 0x2000000
15:22:29 Begin Action: DlgNetwork
15:22:29 ShowDlgNetwork returned: 1
15:22:29 [DlgServerNetwork]
15:22:29 NetworkLibs = 255
15:22:29 TCPPort = 0
15:22:29 TCPPrxy = Default
15:22:29 NMPPipeName = \\.\pipe\MSSQL$SQL2000\sql\query
15:22:29 Result = 1
15:22:29 End Action DlgNetwork
15:22:29 begin ShowDialogsUpdateMask
15:22:29 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
15:22:29 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
15:22:29 Dialog 0x2000000 returned: 1
15:22:29 End Action ShowDialogsHlpr
15:22:29 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
15:22:29 Begin Action ShowDialogsHlpr: 0x8000000
15:22:29 Begin Action: DialogShowSdStartCopy
15:22:30 End Action DialogShowSdStartCopy
15:22:30 begin ShowDialogsUpdateMask
15:22:30 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
15:22:30 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
15:22:30 Dialog 0x8000000 returned: 1
15:22:30 End Action ShowDialogsHlpr
15:22:30 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
15:22:30 End Action ShowDialogs
15:22:30 Begin Action ProcessBeforeDataMove:
15:22:30 DeinstallStart returned (C:\Program Files\Microsoft SQL Server\MSSQL$SQL2000): 0
15:22:30 End Action ProcessBeforeDataMove:
15:22:30 Begin Action SetToolsComponentSelection:
15:22:30 End Action SetToolsComponentSelection:
15:22:30 Begin Action ProcessComponentSelection:
15:22:30 End Action ProcessComponentSelection
15:22:30 Begin Action LogSelectedComponents:
15:22:30 SQLProg
15:22:30 SQLProg\SQLServr
15:22:30 SQLProg\SQLServr\Help
15:22:30 SQLProg\SQLServr\SCMDev
15:22:30 SQLProg\SQLServr\SCMDev\SCMh
15:22:30 SQLProg\SQLServr\SCMDev\SCMX86Lb
15:22:30 SQLProg\SQLServr\SCMDev\SCMALb
15:22:30 SQLProg\SQLServr\Rs1033
15:22:30 SQLProg\SQLServr\RsIntl
15:22:30 SQLProg\SQLServr\ActiveX
15:22:30 SQLProg\SQLServr\System
15:22:30 SQLProg\ReplSupp
15:22:30 SQLProg\ReplSupp\ReplDat
15:22:30 SQLProg\ReplSupp\RepComm
15:22:30 SQLProg\ReplSupp\RepNoDk
15:22:30 SQLProg\ReplSupp\ActiveX
15:22:30 SQLProg\Install
15:22:30 SQLProg\System
15:22:30 SQLProg\SvrExt
15:22:30 SQLProg\SvrExt\Help
15:22:30 SQLProg\SvrExt\SvrExtRs
15:22:30 SQLProg\SvrExt\ResIntl
15:22:30 SQLProg\Dat
15:22:30 SQLProg\DatSmpl
15:22:30 SQLProg\BaseSys
15:22:30 SQLProg\BaseBinn
15:22:30 SQLProg\BaseInst
15:22:30 SQLProg\Symbols
15:22:30 SQLProg\Symbols\EXE
15:22:30 SQLProg\Symbols\DLL
15:22:30 SQLProg\Perfmon
15:22:30 SQLProg\Perfmon\System
15:22:30 SQLProg\Root
15:22:30 MgtTool
15:22:30 MgtTool\SEM
15:22:30 MgtTool\SEM\HTML
15:22:30 MgtTool\SEM\MSD98
15:22:30 MgtTool\SEM\MSD98SYS
15:22:30 MgtTool\SEM\MSD98Res
15:22:30 MgtTool\SEM\MSD98Hlp
15:22:30 MgtTool\SEM\Help
15:22:30 MgtTool\SEM\Res1033
15:22:30 MgtTool\SEM\ResIntl
15:22:30 MgtTool\SEM\MSD98RsI
15:22:30 MgtTool\SEM\ActiveX
15:22:30 MgtTool\SEM\ActiveX\Res1033
15:22:30 MgtTool\SEM\ActiveX\ResIntl
15:22:30 MgtTool\SEM\Scripts
15:22:30 MgtTool\SEM\OLEDB
15:22:30 MgtTool\SEM\OLEDB\Res1033
15:22:30 MgtTool\SEM\OLEDB\ResIntl
15:22:30 MgtTool\Profiler
15:22:30 MgtTool\Profiler\Help
15:22:30 MgtTool\Profiler\Res1033
15:22:30 MgtTool\Profiler\ResIntl
15:22:30 MgtTool\Qryanlz
15:22:30 MgtTool\Qryanlz\Help
15:22:30 MgtTool\Qryanlz\Res1033
15:22:30 MgtTool\Qryanlz\ResIntl
15:22:30 MgtTool\DTCCLi
15:22:30 MgtTool\Wzcnflct
15:22:30 MgtTool\Wzcnflct\WzcnHlp
15:22:30 MgtTool\Wzcnflct\Wzcn1033
15:22:30 MgtTool\Wzcnflct\WzcnOthr
15:22:30 MgtTool\Wzcnflct\WzcnCmn
15:22:30 MgtTool\UtilSys
15:22:30 MgtTool\UtilBinn
15:22:30 Connect
15:22:30 Connect\ConnSys
15:22:30 Books
15:22:30 Books\Bookso
15:22:30 Books\Bookso\Utils
15:22:30 DevTools
15:22:30 DevTools\Dbg Int
15:22:30 DevTools\Dbg Int\Dbg Int Common
15:22:30 DevTools\Dbg Int\EXE
15:22:30 CoreRepl
15:22:30 CoreRepl\Res1033
15:22:30 CoreRepl\ResIntl
15:22:30 Core
15:22:30 Core\Res1033
15:22:30 Core\ResOther
15:22:30 Repostry
15:22:30 Repostry\RepstSys
15:22:30 Repostry\Res1033
15:22:30 Repostry\ResIntl
15:22:30 CoreMisc
15:22:30 CoreMisc\ActiveX
15:22:30 CoreMisc\ActiveX\Res1033
15:22:30 CoreMisc\ActiveX\ResIntl
15:22:30 CoreMisc\Res1033
15:22:30 Monarch
15:22:30 Monarch\Monr1033
15:22:30 Monarch\MonrIntl
15:22:30 Jet
15:22:30 CoreInst
15:22:30 CoreCOM
15:22:30 CoreCOM\Res1033
15:22:30 CoreCOM\ResIntl
15:22:30 CoreTool
15:22:30 CoreTool\Res1033
15:22:30 CoreTool\ResOther
15:22:30 DBLibCli
15:22:30 SFExt
15:22:30 SFExt\ActiveX
15:22:30 SFExt\ActiveX\Res1033
15:22:30 SFExt\ActiveX\ResIntl
15:22:30 SFExt\Res1033
15:22:30 SFExt\ResIntl
15:22:30 Trace
15:22:30 Trace\Res1033
15:22:30 Trace\ResOther
15:22:30 MiscCore
15:22:30 MC
15:22:30 MC\MC1033
15:22:30 MC\MCIntl
15:22:30 MC\Help
15:22:30 SQLMgr
15:22:30 SQLMgr\Res1033
15:22:30 SQLMgr\ResIntl
15:22:30 SvrTool
15:22:30 SvrTool\Res1033
15:22:30 SvrTool\ResIntl
15:22:30 DTSUI
15:22:30 DTSUI\Res1033
15:22:30 DTSUI\ResIntl
15:22:30 MSOlap
15:22:30 MSOlap\Res1033
15:22:31 MSOlap\ResIntl
15:22:31 ATL
15:22:31 ATL\winnt
15:22:31 ATL\win9x
15:22:31 MFC42U
15:22:31 VC
15:22:31 VB
15:22:31 SQLAdHlp
15:22:31 SQLAdHlp\Res1033
15:22:31 SQLAdHlp\ResOther
15:22:31 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
15:22:31 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
15:22:31 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
15:22:31 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
15:22:31 End Action LogSelectedComponents
15:22:31 Begin Action InstallPkgs:
15:22:31 Begin Action: Locked Connectivity Files Check
15:22:31 ConnectivityLocked returned: 0
15:22:31 The operation completed successfully.

15:22:31 End Action: Locked Connectivity Files Check
15:22:31 Setup is installing Microsoft Data Access Components (MDAC) ...
15:22:31 F:\SQL2000\DEV\x86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
15:22:41 ExitCode: 0
15:22:41 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
15:22:41 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg "F:\SQL2000\DEV\x86\Other\dtcsetup.exe" -LogFile "C:\WINDOWS\sqlstp.log"
15:22:41 Process Exit Code: (0)
15:22:41 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
15:22:41 Setup is installing HTML Help ...
15:22:42 HTML Help installer exit code: 0
15:23:03 End Action InstallPkgs
15:23:03 Begin Action MoveFileData:
15:23:03 Enabled SELFREGISTERBATCH
15:23:03 Enabled CORECOMPONENTHANDLING
15:23:24 Begin Action: MoveFileDataSpecial
15:23:24 End Action: MoveFileDataSpecial
15:23:24 End Action MoveFileData
15:23:24 Begin Action ProcessAfterDataMove:
15:23:24 F:\SQL2000\DEV\x86\Binn\hhcol.exe C:\Program Files\Microsoft SQL Server\80\Tools\Books
15:23:25 End Action ProcessAfterDataMove
15:23:25 Begin Action BuildServer:
15:23:25 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath "C:\Program Files\Microsoft SQL Server\MSSQL$SQL2000\binn\sqlservr.exe" -Service "MSSQL$SQL2000"
15:23:25 Process Exit Code: (0)
15:23:25 Begin Action: CreateRegistrySetSQL
15:23:25 End Action: CreateRegistrySetSQL
15:23:25 Begin Action: RegWriteSetupEntry
15:23:25 End Action: RegWriteSetupEntry
15:23:25 Begin Action: CreateSer
15:23:25 End Action: CreateSer
15:23:25 Begin Action: SkuIt
15:23:25 End Action: SkuIt
15:23:26 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL Server\MSSQL$SQL2000 returned: 0, 0
15:23:26 SetRegSecuritySQLAndAdmin for Software\Microsoft\Microsoft SQL Server\SQL2000 returned: 0, 0
15:23:26 Begin Action: UpdateSystemPath
15:23:26 Path successfully updated.
15:23:26 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn15:23:26 End Action: UpdateSystemPath
15:23:27 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I SQL2000 -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 132710 -U sa -P
################################################## #############################

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=SERVER1\SQL2000;UID=sa;PWD=;databas e=master

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

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

driver={sql server};server=SERVER1\SQL2000;UID=sa;PWD=;databas e=master

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

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

driver={sql server};server=SERVER1\SQL2000;UID=sa;PWD=;databas e=master

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

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

SQL Server configuration failed.

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

15:25:29 Process Exit Code: (-1)

Thanks

Peso · August 21st, 2007, 10:01 AM

Are you trying to install SQL Server 2000 on Windows XP?

Peso · August 21st, 2007, 10:02 AM

See http://www.microsoft.com/sql/prodinf...uirements.mspx

Pusstiu · August 21st, 2007, 10:03 AM

yes

Jeff Moden · August 21st, 2007, 06:19 PM

You must install "real" versions of SQL Server only on Windows Servers... cannot be installed on a mere desktop. Only the Developer's editions can be installed on desktop boxes. If you get caught using the Developer's Edition as a production DB, the fines are very, very steep.

--Jeff Moden

Pusstiu · August 22nd, 2007, 01:59 AM

I have Sql 2000 developer's edition, and the desktop's OS is Windows Xp professional. i heard that the problem may be caused by a firewall or an antivirus software, something related to the security probably, but i'm not sure

Jeff Moden · August 22nd, 2007, 06:46 AM

You are correct... the SQL Server 2000 Developer's Edition and Windows XP Professional should play just fine together... they do on my desktop.

You're also correct that you should turn off all firewalls and antivirus software and be logged in as the local system administrator all while you are disconnected from the internet to do the install. Of course, don't forget to turn it all back on after the install.

--Jeff Moden