You may receive the "Setup was unable to validate the logged user" error message when you install SQL Server 2000 Service Pack 3 (814844)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions) SP3
Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit 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 earlier versions 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 If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
To work around this problem, use any one of the following methods.

Method 1

Change the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo\DSQUERY value to DBNETLIB. To change the value, follow these steps:
  1. On the Start menu, click Run.
  2. Type Regedit, and then click OK.
  3. In the Registry Editor, locate the following Registry key path:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
  4. In the right pane of Registry Editor, double click DSQUERY key.
  5. On the Edit String dialog box, in Value data textbox, type DBNETLIB and then click OK.
  6. Close Registry Editor.

Method 2

  • Make sure that the registry key, NtfsDisable8dot3NameCreation, is set to 0. A value of 0 ensures that folders with spaces can be accessed by using short names. To set the registry key, follow these steps:
    1. On the Start menu, click Run.
    2. Type Regedit, and then click OK.
    3. In the Registry Editor, locate the following Registry key path:

      HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem
    4. In the right-hand side of the Registry Editor, double click the NtfsDisable8dot3NameCreation key.
    5. In the Edit String dialog box, in the Value data text box, type 0. Click OK.
    6. Close Registry Editor.
  • Make sure that the TEMP or the TMP environment variables do not have spaces. To verify this, use these steps:
    1. Right-click My Computer, and then click Properties.
    2. On the Advanced tab, click Environment Variables.
    3. In the User Variables for <logged 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.
    4. 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.
    5. If any of the variable values have spaces, create a new temporary folder that does not have any spaces (C:\Temp, for example), and then specify it as the variable value for the TEMP and the TMP environment variables.

MORE INFORMATION

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 recorded in the SQL Server Service Pack installation log that 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, this is the text that is recorded:

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 Authentication

If you are using SQL Server 2000 SP3 with SQL Authentication, this is the text that is recorded:

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

REFERENCES

For additional information about how to download the latest version of MDAC, visit the following Microsoft Web site:

http://www.microsoft.com/data/download.htm

For additional 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:

307255 Diagnose problems and reconfigure MDAC installations

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

290211 How to obtain the latest SQL Server 2000 service pack

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

308831 SQL Server 2000 Service Pack 1 Setup fails with 703 error message "An internal read error"

Modification Type:MajorLast Reviewed:3/3/2006
Keywords:kbtshoot kbBug kbUpgrade kbRegistry kberrmsg kbprb KB814844 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.