Re: AUTHENTICATION TO APPLY SP3

From: Jim K (jking@shumakerengineering.com)
Date: 02/03/03 

From: "Jim K" <jking@shumakerengineering.com>
Date: Mon, 3 Feb 2003 08:27:24 -0800

I am receiving the same error.

I went to apply the fix recommended below, but I do not
have the value DSQUERY. Could that be my problem?
Should I add this value (as a string I assume)?

Additionally, When I apply the patch it asks me to choose
an instance if SQL. I only have one instance of SQL
installed, however it is named. When I get to this screen
in the patch intall, I do not have the option to change
it from default to my named instance. The option is
greyed-out. Is this ok, or should I be able to change it?

Thanks in advance.

>-----Original Message-----
>What's the error message that you're getting? If you're
not getting any
>error message at all, you're probably running MDAC 2.6
and you need check
>the following registry key:
>
>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\
ConnectTo\DSQUERY
>
>Set it to DBNETLIB if it's currently set to anything
else.
>
>If you're getting an error message about setup being
unable to validate you,
>try replacing the current dbmslpcn.dll file with the one
from SP3 and try
>running setup again. This is usually in the
windows\system32 directory.
>
>Hope this helps!
>Stephen Dybing
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Please reply to the newsgroups only, thanks.
>
>"Joe D" <jdanajovits@cabreraservices.com> wrote in
message
>news:08f701c2c932$5b0b2500$d3f82ecf@TK2MSFTNGXA10...
>> Info Returned from SQLScan:
>> SQL Server 2000 RTM Standard Edition
>> ssnetlib.dll @version=2000.80.194.0
>> sqlservr.exe @version=2000.80.194.0
>>
>> - Running the patch from server console
>> - Logged on as administrator
>>
>>
>>
>> Problem:
>> When I try to run the SP3, the process fails to
>> authenticate with either the sa user or the current
>> windows user.
>>
>> These accounts and passwords are good because I can get
>> access to query analyzer using either account.
>>
>> Any help would be appreciated!
>>
>> Joe D.
>>
>>
>
>
>.
>

Relevant Pages

  • Re: Problems Setting Delegate Permissions
    ... for the users that are in 'protected accounts'. ... After installing the patch http://support.microsoft.com/?kbid=913807, ... Client receives following error when adding or removing a delegate from ... problems and the client would not see an error message, ...
    (microsoft.public.exchange.admin)
  • Re: SQL Timeout Error
    ... "Robert Lakinski" wrote: ... but you can access data in Sql server via MS ... I don't know why I got the error message. ...
    (microsoft.public.sqlserver.server)
  • RE: Increasing ICMP Echo Requests
    ... SQL servers fall under the purview of security-related staff who subscribe ... Alright, if the patch works, there are no foulups, there is nothing else to ... > Well no I don't expect Joe shmoe to know this, ... > technical IT security event. ...
    (Incidents)
  • Re: Microsoft AppCenter and W32/SQLSlammer
    ... I am aware of the issue with AppCenter, and I would also like to pass ... As of late last night the AppCenter patch issue had not been ... There was a handle leak introduced into SQL in SQL Service Pack 2. ... Cisco have said very little, apart from recommending that people patch, ...
    (NT-Bugtraq)
  • Re: Multilingual versions of SQL Express 2005 available ? Where ?
    ... The error code alone is not sufficient. ... error code which is represented in the parameters used to format the SQL ... language is used. ... > we may consider provide localized error message according to the error ...
    (microsoft.public.sqlserver.setup)