Re: SQL Server 2000 SP3 Validation Error

From: Dan Savage (Dan.Savage@HobbsHerder.com)
Date: 01/30/03 

From: "Dan Savage" <Dan.Savage@HobbsHerder.com>
Date: Wed, 29 Jan 2003 16:30:52 -0800

Hi Dan & Prasanna,

The source of the problem was the version of MDAC. I
hadn't updated it to 2.7 as you both correctly surmised.
Once I updated to 2.7, I was able to install SP3.

Thanks again for your prompt assistance.

Dan

>-----Original Message-----
>What version of MDAC are you running?
>You may have this error if you are running MDAC 2.6.
>The temporary workaround is to change the value of this
registry key to
>"DBNETLIB":
>
>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\C
onnectTo\DSQUERY
>
>Thanks
>
>Prasanna Krishnan
>
>Program Manager, SQL
>
>
>--
>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
>
>
>.
>

Quantcast