Re: SQL Server 2000 SP3 Validation Error

From: SQL Server Development Team [MSFT] (sqldev@microsoft.com)
Date: 01/29/03 

From: "SQL Server Development Team [MSFT]" <sqldev@microsoft.com>
Date: Wed, 29 Jan 2003 13:09:23 -0800

The steps below should address your problem.

Thanks,
Dan Winn
Program Manager, SQL Server Server, Microsoft Corp.

SOLUTION: Validating a user error during SP3 upgrade

Problem Description:
Several of you have encountered problems running the Service Pack 3 setup
where setup fails very early on while "validating a user". This problem can
occur when MDAC version 2.6 or earlier is present on the machine at the time
of upgrade. Those who received later versions of the server network library
components of MDAC through a later upgrade (MDAC 2.7 as part of Windows XP
Pro for example) will not encounter this problem.

Resolution/workaround:
As Jeff Boyd noted elsewhere in the newsgroups, you can change the "DSQuery"
entry in the registry as a temporary workaround. The key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo\DSQuery
value to "DBNETLIB".

We will get some type of official KB article out in the near future. For
now, I hope this helps those of you encountering this issue.

Regards,
Tom Casey.

PS -- I am cross-posting this and a few of the more common
problems/resolutions to multiple newsgroups. Please pardon the duplication. 

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Dan Savage" <Dan.Savage@HobbsHerder.com> wrote in message
news:09bb01c2c7d9$e20fc470$cef82ecf@TK2MSFTNGXA08...
> I'm trying to apply the SP3 to the default installation of
> SQL 2000 and cannot get past the "username/password
> validation error".
>
> I've tried clicking the sa radio button and supplying the
> sa password as well as clicking the "login account" radio
> button.
>
> There is only the default SQL Server installed on the
> machine. I'm having no trouble accessing SQL Server using
> the same account in Enterprise Manager.
>
> I was able to successfully run the installer on my local
> machine, but am having problems running the update on the
> remote web server through Terminal Services Client.
>
> I checked the local security settings discussed in the pre-
> installation tasks and they're set according to the
> instructions.
>
> I had previously installed MS02-61, so there's no security
> risk, but I would like to complete the SP3 installation.
>
> TIA,
>
> Dan