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

Back to the top

Method 1

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.

Back to the top

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.

Back to the top

Back to the top

SQL Server 2000 SP3 with Microsoft Windows NT Authentication

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.

Back to the top

SQL Server 2000 SP3 with SQL Authentication

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

Back to the top