为什么安装SQL2KSP4补丁时老是出现安装程序无法验证密码的问题？？？？
我用的是xp系统，数据库为sql2000pro个人版，版本信息是Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)SQL Server网络实用工具启用的协议为命名管道和TCP/IP,SQL Server客户端网络实用工具按顺序启用协议为TCP/IP,Named PipesCorporation，TCP/IP的默认端口为1433
以前连jdbc时出现error establishing socket的错误，用netstat查了下发现1433端口老是没有打开，听别人说要下个sp3或sp4补丁，我就分别下了sp3和sp4补丁，装上sp4后问题解决了。
后来重装了一次系统，再装sp4时老是出现安装程序无法验证密码的问题，我改装sp3可还是出现那个问题，我装sql2000pro时选择的是本地系统帐户，身份验证模式为sql身份验证模式，sa密码为833919，默认的实例，打开查询分析器，输入sa密码833919，查询分析器打开成功，这说明sa密码没错，改为windows身份验证模式之后再装sp4还是出现那样的问题，把sql2000pro卸了再重装，然后装sp4，甚至把整个系统重装，然后把注册表里关于sql的全部都删了，然后再装sql2000pro,sp4后还是出现那样的问题
在网上查了下说把注册表项HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo\DSQUERY 的值更改为 DBNETLIB或是将注册表HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem里的“NtfsDisable8dot3NameCreation”项值设置为 0，可我找到注册表里的“DSQUERY”项时发现它的值已经是DBNETLIB，“NtfsDisable8dot3NameCreation”项的值也已经是0，所以应该不是这方面的原因，还有就是确保TEMP或TMP环境变量没有空格，我看了下我的TEMP和TMP均为%USERPROFILE%\Local Settings\Temp，也没有任何尾随空格，所以也不是这方面的原因
我的Sqlsp.log的SQL Server Service Pack 安装日志中的记录信息为:
17:45:20 Begin Setup
17:45:20 Version on Media: 8.00.2039
17:45:20 Mode = Normal
17:45:20 ModeType = NORMAL
17:45:20 Loading library - sqlsut.dll (#L1)
17:45:20 Begin: SetupInitialize()
17:45:20 End: SetupInitialize()
17:45:20 Begin: CheckFixedRequirements()
17:45:20 Platform ID: 0xf000000
17:45:20 Version: 5.1.2600
17:45:20 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.2900.2877
17:45:20 End: CheckFixedRequirements()
17:45:20 Begin Action: CheckRequirements
17:45:20 Processor Architecture: x86 (Pentium)
17:45:20 Service Pack: 512
17:45:20 ComputerName: DB02172F6AE645C
17:45:20 User Name: Administrator
17:45:20 IsAllAccessAllowed returned: 1
17:45:20 OS Language: 0x804
17:45:20 End Action CheckRequirements
17:45:21 CreateSetupTopology(DB02172F6AE645C), Handle : 0x15641c8, returned : 0
17:45:21 CreateSetupTopology returned : 0, Handle : 0x15641c8
17:45:21 Topology Type : 1, Return Value : 0
17:45:21 ST_GetPhysicalNode returned : 0, PNHandle : 0x1564210
17:45:21 PN_EnumerateEx returned : 0
17:45:21 PN_GetSQLStates returned : 0, SqlStates : 0x88008225
17:45:21 PN_StartScan [0x1564210] returned : 0
17:45:21 PN_GetNext [0x1564210] returned : 0, Handle: [0x15647a8]
17:45:21 SQLI_GetPackageId [0x15647a8] returned : 0, PackageId = 0x2
17:45:21 SQLI_GetVersion [0x15647a8] returned : 0, Version = 8.00.194
17:45:21 PN_GetNext [0x1564210] returned : 18, Handle: [0x0]
17:45:21 ReleaseSetupTopology
17:45:21 This combination of Package and Operating System allows a full product install.
17:45:21 Begin: SetupInstall()
17:45:21 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
17:45:21 CommonFilesDir=C:\Program Files\Common Files
17:45:21 Windows Directory=C:\WINDOWS\
17:45:21 Program Files=C:\Program Files\
17:45:21 TEMPDIR=C:\DOCUME~1\ADMINI~1.DB0\LOCALS~1\Temp\
17:45:21 End: SetupInstall()
17:45:21 Begin: ShowDialogs()
17:45:21 Initial Dialog Mask: 0x8300037, Disable Back=0x1
17:45:21 Begin Action ShowDialogsHlpr: 0x1
17:45:21 Begin Action: DialogShowSdWelcome
17:45:23 End Action DialogShowSdWelcome
17:45:23 Dialog 0x1 returned: 1
17:45:23 End Action ShowDialogsHlpr
17:45:23 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
17:45:23 Begin Action ShowDialogsHlpr: 0x2
17:45:23 Begin Action: DialogShowSdMachineName
17:45:23 ShowDlgMachine returned: 1
17:45:23 Name = DB02172F6AE645C, Type = 0x1
17:45:23 End Action DialogShowSdMachineName
17:45:23 begin ShowDialogsUpdateMask
17:45:23 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 0
17:45:23 Updated Dialog Mask: 0xbf00035, Disable Back = 0x1
17:45:23 Dialog 0x2 returned: 0
17:45:23 End Action ShowDialogsHlpr
17:45:23 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
17:45:23 Begin Action ShowDialogsHlpr: 0x4
17:45:23 Begin Action: DialogShowSdInstallMode
17:45:23 ShowDlgInstallMode returned: 1
17:45:23 InstallMode : 0x2
17:45:23 End Action DialogShowSdInstallMode
17:45:23 begin ShowDialogsUpdateMask
17:45:23 nFullMask = 0xbf00035, nCurrent = 0x4, nDirection = 1
17:45:23 Updated Dialog Mask: 0xb000627, Disable Back = 0x1
17:45:23 Dialog 0x4 returned: 1
17:45:23 End Action ShowDialogsHlpr
17:45:23 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
17:45:23 Begin Action ShowDialogsHlpr: 0x20
17:45:23 Begin Action: DialogShowSdLicense
17:45:24 End Action DialogShowSdLicense
17:45:24 Dialog 0x20 returned: 1
17:45:24 End Action ShowDialogsHlpr
17:45:24 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
17:45:24 Begin Action ShowDialogsHlpr: 0x200
17:45:24 Begin Action: DialogShowSdInstanceName
17:45:24 Begin Action: ShowDlgInstanceName
17:45:25 Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion\CSDVersionNumber key not found, no SP installed
17:45:25 The language on the CD is 2052 and installed is 2052
17:45:25 End Action : Verify Language
17:45:25 SKU is : Personal Edition
17:45:25 End Action: ShowDlgInstanceName
17:45:25 ShowDlgInstanceName returned : 0
17:45:25 InstanceName : MSSQLSERVER
17:45:25 End Action DialogShowSdInstanceName
17:45:25 begin ShowDialogsUpdateMask
17:45:25 nFullMask = 0xb000627, nCurrent = 0x200, nDirection = 0
17:45:25 Updated Dialog Mask: 0xbc00627, Disable Back = 0x1
17:45:25 Dialog 0x200 returned: 0
17:45:25 End Action ShowDialogsHlpr
17:45:25 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
17:45:25 Begin Action ShowDialogsHlpr: 0x400
17:45:25 Begin Action: DialogShowSdMaintain
17:45:25 ShowDlgMaintainInstall returned : 1
17:45:25 Type : 0xc
17:45:25 CreateSetupTopology(DB02172F6AE645C), Handle : 0x15641c8, returned : 0
17:45:25 CreateSetupTopology returned : 0, Handle : 0x15641c8
17:45:25 Topology Type : 1, Return Value : 0
17:45:25 ST_GetPhysicalNode returned : 0, PNHandle : 0x1564210
17:45:25 PN_EnumerateEx returned : 0
17:45:25 PN_GetSQLStates returned : 0, SqlStates : 0x88008225
17:45:25 PN_GetInstance for MSSQLSERVER [0x1564210] returned : 0
17:45:25 SQLI_GetPackageId [0x15647a8] returned : 0, PackageId = 0x2
17:45:25 SQLI_GetVersion [0x15647a8] returned : 0, Version = 8.00.194
17:45:25 SQLI_GetSQLStates for MSSQLSERVER [0x15647a8] returned : 0, SQLStates: 0xc00205
17:45:25 SQLI_GetInstallPath [0x15647a8] returned : 0, Path = e:\didi\sql\ying yong cheng xu\MSSQL
17:45:25 SQLI_GetDataPath [0x15647a8] returned : 0, DataPath = e:\didi\sql\ying yong cheng xu\MSSQL
17:45:25 SQLI_GetVersion [0x15647a8] returned : 0, Version = 8.00.194
17:45:25 SQLI_GetRegKeyRoot [0x15647a8] returned : 0, RegKeyRoot = Software\Microsoft\MSSQLServer
17:45:25 SQLI_GetPackageName [0x15647a8] returned : 0, szPackage = Personal Edition
17:45:25 SQLI_GetPackageId [0x15647a8] returned : 0, PackageId = 0x2
17:45:25 Previous Install Path: e:\didi\sql\ying yong cheng xu\MSSQL
17:45:25 Previous Install Data: e:\didi\sql\ying yong cheng xu\MSSQL
17:45:25 Previous Install Version: 8.00.194
17:45:25 ReleaseSetupTopology
17:45:25 End Action DialogShowSdMaintain
17:45:25 begin ShowDialogsUpdateMask
17:45:25 nFullMask = 0xbc00627, nCurrent = 0x400, nDirection = 1
17:45:25 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
17:45:25 Dialog 0x400 returned: 1
17:45:25 End Action ShowDialogsHlpr
17:45:25 ShowDialogsGetDialog returned: nCurrent=0x2000,index=13
17:45:25 Begin Action ShowDialogsHlpr: 0x2000
17:45:25 Begin Action: DialogShowSdUpgrade
17:45:25 ShowDlgUpgrade returned : 1
17:45:25 Checking databases on instance 'MSSQLSERVER'
17:45:25 Authenticate access
17:45:25 Begin SDPassword Dialog
17:45:31 End SDPassword Dialog
17:45:31 C:\DOCUME~1\ADMINI~1.DB0\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 6 -Service MSSQLSERVER
17:45:46 Process Exit Code: (0)
17:45:46 C:\DOCUME~1\ADMINI~1.DB0\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022
17:45:57 Process Exit Code: (0)
17:45:57 E:\didi\SQL\SQL2KSP4\SQL2KSP4\SQL2KSP4\x86\BINN\osql.exe -Slpc:DB02172F6AE645C -n -d master -Q "exit" -o "C:\DOCUME~1\ADMINI~1.DB0\LOCALS~1\Temp\sqlsp.out" -Usa -P"
17:45:57 Process Exit Code: (1)
17:46:01 C:\DOCUME~1\ADMINI~1.DB0\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 6 -Service MSSQLSERVER
17:46:16 Process Exit Code: (0)
17:46:17 安装程序无法验证服务器的状态，以便进行升级。请验证服务器能够启动而且您提供了有效的 sa 密码，然后重新启动安装程序。
17:46:17 End Action DialogShowSdUpgrade
17:46:17 End: ShowDialogs()
17:46:17 Action CleanUpInstall:
17:46:17 Installation Failed.
我为这个问题耽误我好几天的时间了，都快郁闷坏了，哪个大虾能帮我解决问题，小弟将感激不尽 首先倒下苦水，很讨厌用XP系统来装数据库，不管是MSSQL还是ORACLE，在XP系统上经常出现异常的问题
所以建议装数据库的系统最好为2000系列的 （WIN系统的话）
在安装之前检查计算机上所有关于数据库的文件是否已经删除，特别是注册表，因为安装过程中，安装程序会检查
注册表，如果已经存在的健值会不加以改写，造成保留了原来的值，并未更新
在安装的时
最好在SQL Server网络实用工具启用的协议中把IPX也选上，这样就可以通过计算机名来访问
选择身份验证时选择SQL验证模式，可以先设置为空密码模式
如果还是不行，建议换2000的系统:lol 偶最怕XP操作系统 我现在也是碰到这个问题，都郁闷了好些天了，还没能解决，哪位神仙哥哥或姐姐，指点一下呀！
页:
[1]