Microsoft KB Archive/814844

= You may receive the &quot;Setup was unable to validate the logged user&quot; error message when you install SQL Server 2000 Service Pack 3 =

Article ID: 814844

Article Last Modified on 1/30/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 3

-



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



SYMPTOMS
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.



WORKAROUND
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 1
Change the registry key  value to DBNETLIB. To change the value, follow these steps:  Click Start, click Run, type regedit, and then click OK. In Registry Editor, locate the following registry key:

 Double-click DSQUERY. In Value data box, type DBNETLIB, and then click OK. Exit Registry Editor.

Method 2
 Make sure that the  registry key is set to 0. When this key is set to 0, you can access folders that have spaces in their names by using short names. To set the registry key, follow these steps:  Click Start, click Run, type regedit, and then click OK.</li> In Registry Editor, locate the following registry key:

</li> Double-click NtfsDisable8dot3NameCreation.</li> In the Value data box, type 0, and then click OK.</li> Exit Registry Editor.</li></ol> </li> 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.</li> On the Advanced tab, click Environment Variables.</li> In the User Variables for  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.</li> 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.</li> 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.</li></ol> </li></ul>

<div class="moreinformation_section">

MORE INFORMATION
When the SQL Server 2000 Service Pack 3 installation fails with the error messages that are mentioned in the &quot;Symptoms&quot; 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: <pre class="fixed_text">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 &quot;exit&quot; -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 Authentication
If you are using SQL Server 2000 SP3 with SQL Authentication, the following information is logged: <pre class="fixed_text">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&quot;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

<div class="references_section">