Article ID: 814844 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/256986/ )Description of the Microsoft Windows registry
When you install Microsoft SQL Server 2000 Service Pack 3 (SP3) on a computer that has Microsoft Data Access Components (MDAC) version 2.6 or an earlier version of MDAC installed, the installation may fail. You may receive the following error messages:
Error message 1
Setup was unable to validate the logged user. Press Retry to enter another option, or Cancel to exit setup.
Error message 2
Setup was unable to verify the state of the server for an upgrade. Verify the server can start and that you provided a valid sa password and restart setup.
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
To work around this problem, use any one of the following methods.
Method 1Change the registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo\DSQUERYvalue to DBNETLIB. To change the value, follow these steps:
When the SQL Server 2000 Service Pack 3 installation fails with the error messages that are mentioned in the "Symptoms" section, the following information is logged in the SQL Server Service Pack installation log file. This file is named Sqlsp.log.
SQL Server 2000 SP3 with Microsoft Windows NT AuthenticationIf you are using SQL Server 2000 SP3 with Windows NT Authentication, the following information is logged:
12:07:09 Authenticate access 12:07:09 Begin SDPassword Dialog 12:07:10 End SDPassword Dialog 12:07:10 C:\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4010 \-T4022 \-m 12:07:10 Process Exit Code: (0) 12:07:10 D:\sp3\x86\BINN\osql.exe -Slpc:<SQL Server Name> -n -d master -Q "exit" -E 12:07:56 Process Exit Code: (1) 12:08:00 C:\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 6 -Service MSSQLSERVER 12:08:15 Process Exit Code: (0) 12:08:16 Setup was unable to verify the state of the server for an upgrade. Verify the server can start and that you provided a valid sa password and restart setup. 12:08:16 End Action DialogShowSdUpgrade 12:08:16 End: ShowDialogs() 12:08:16 Action CleanUpInstall: 12:08:16 Installation Failed.
SQL Server 2000 SP3 with SQL AuthenticationIf you are using SQL Server 2000 SP3 with SQL Authentication, the following information is logged:
11:52:22 Begin: CheckSAPassword 11:52:22 Begin: LogOnUsingBlankSA 11:52:22 D:\sp3\x86\BINN\osql.exe -Slpc:<SQL Server Name> -E -n -d master -Q"Exit(declare @ret int if (select count(*) from master..syslogins where name='sa' AND ( (1 = pwd 11:53:07 Process Exit Code: (1) 11:53:07 End: LogOnUsingBlankSA 11:53:07 Error while detecting SA Blank Password. 12:06:03 Error : While detecting blank pwd 12:06:03 End Action DialogShowSdUpgrade 12:06:03 End: ShowDialogs() 12:06:03 Action CleanUpInstall: 12:06:03 Installation Failed
For more information about how to download the latest version of MDAC, visit the following Microsoft Web site:
http://msdn2.microsoft.com/en-us/data/aa937695.aspxFor more information about how to determine the current version of MDAC on your computer, click the following article number to view the article in the Microsoft Knowledge Base:
307255For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/307255/ )Diagnose problems and reconfigure MDAC installations
(https://support.microsoft.com/kb/290211/ )How to obtain the latest SQL Server 2000 service pack
(https://support.microsoft.com/kb/328290/ )"Setup was unable to verify the state of the server for an upgrade" error message when SQL Server Service Pack 2 Setup stops responding
(https://support.microsoft.com/kb/308831/ )SQL Server 2000 Service Pack 1 Setup fails with 703 error message "An internal read error"