Re: AUTHENTICATION TO APPLY SP3

From: Denny (mrdenny@gamespy.com)
Date: 02/10/03


From: "Denny" <mrdenny@gamespy.com>
Date: Mon, 10 Feb 2003 14:08:49 -0800


Did you try starting the SQL Server in single user mode? This worked from
me. From ../binn
sqlservr -c -m

--
Denny Cherry
Database Administrator
GameSpy Industries
"Jim K." <jking@shumakerengineering.com> wrote in message
news:002401c2cf8f$88761c30$a201280a@phx.gbl...
> I have made all of the recommended changes, but still
> cannot get past the validation portion of the SP3
> installation.
>
>  - I installed MDAC 2.7 SP1
>  - Replaced the dbmslpcn.dll in my system32 dir with the
> one in SP3
>  - I added the value DSQUERY > DBNETLIB to
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\
> ConnectTo\
>  - I have tried to run it as the administrator account on
> the local machine
> - tried the sa password validation
> - I ran Sqlredis.exe. (although it didnt appear to do
> much, just unpack and quit)
>
>
> But I think my problem is before the validation window,
> in the Named Instance window. I cannot choose a named
> instance.  The check-box is greyed out, it will not allow
> me to change it from the default instance.
>
> Any idea why this is?
>
>
> Thanks in advance.
>
> >-----Original Message-----
> >You should probably call support and get an expert's
> opinion, but if it were
> >me, I'd probably try updating to MDAC 2.7 SP1 manually,
> rebooting the
> >computer, and trying to install SP3 again. :-)
> Sqlredis.exe does this and is
> >in the x86\other directory where you expanded the
> service pack download.
> >
> >DSQUERY is indeed a string value.
> >
> >Hope this helps!
> >Stephen Dybing, Microsoft
> >
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >Please reply to the newsgroups only, thanks.
> >
> >"Jim K" <jking@shumakerengineering.com> wrote in message
> >news:04b901c2cba1$22553d60$8ef82ecf@TK2MSFTNGXA04...
> >> 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.
> >> >>
> >> >>
> >> >
> >> >
> >> >.
> >> >
> >
> >.
> >