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:
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.
Make sure that the TEMP environment variable and the TMP environment variable do not contain spaces. To verify this, follow these steps:
Right-click My Computer, and then click Properties.
On the Advanced tab, click Environment Variables.
In the User Variables for logged-on user list, select TMP and then click Edit. Make sure that there are no spaces in the Variable Value text box, particularly any trailing spaces, and then click OK.
Select TEMP, and then click Edit. Make sure that there are no spaces in the Variable Value text box, particularly any trailing spaces, and then click OK.
If any of the variable values contain spaces, create a new temporary folder that does not contain spaces. For example, you can create the C:\Temp folder. Then, specify the new folder as the variable value for the TEMP environment variable and for the TMP environment variable.
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 Authentication
If 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 MSSQLSERVER12: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 Authentication
If you are using SQL Server 2000 SP3 with SQL Authentication, the following information is logged:
11:52:22 Begin: CheckSAPassword11:52:22 Begin: LogOnUsingBlankSA11: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 = pwd11:53:07 Process Exit Code: (1) 11:53:07 End: LogOnUsingBlankSA11:53:07 Error while detecting SA Blank Password. 12:06:03 Error : While detecting blank pwd 12:06:03 End Action DialogShowSdUpgrade12: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: