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

Article translations Article translations
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:
256986 Description of the Microsoft Windows registry
Expand all | Collapse all

On This Page

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
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo\DSQUERY
value to DBNETLIB. To change the value, follow these steps:
  1. Click Start, click Run, type regedit, and then click OK.
  2. In Registry Editor, locate the following registry key:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
  3. Double-click DSQUERY.
  4. In Value data box, type DBNETLIB, and then click OK.
  5. Exit Registry Editor.

Method 2

  • Make sure that the
    NtfsDisable8dot3NameCreation
    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:
    1. Click Start, click Run, type regedit, and then click OK.
    2. In Registry Editor, locate the following registry key:
      HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem
    3. Double-click NtfsDisable8dot3NameCreation.
    4. In the Value data box, type 0, and then click OK.
    5. Exit Registry Editor.
  • Make sure that the TEMP environment variable and the TMP environment variable do not contain spaces. To verify this, follow 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-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.
    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 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.

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 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 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:
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 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.aspx
For 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:
307255 Diagnose problems and reconfigure MDAC installations
For more 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"

Properties

Article ID: 814844 - Last Review: February 27, 2014 - Revision: 9.2
APPLIES TO
  • Microsoft SQL Server 2000 Service Pack 3
Keywords: 
kbnosurvey kbarchive kbtshoot kbbug kbupgrade kbregistry kberrmsg kbprb KB814844

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com