Home All Groups Group Topic Archive Search About

Re: Strange problems accessing SQL server with windows 2000 window



Author
27 May 2005 8:55 PM
Mike Allen
I'm having same issue.  My XP client can connect to SQL using TCP/IP while
2000 can only connect with Named Pipes.  Both client computers are in same
domain as the SQL server.  Any ideas?

Show quoteHide quote
"Simon Lidberg [MSFT]" wrote:

> Are the clients connecting to the the server using integrated security? Are
> they connecting using the same network protocols?
>
> Simon
> This posting is provided "as is" with no warranties and confers no rights.
>
> "Craig Pickles" <reply2cr***@hotmail.com> wrote in message
> news:gt5e219f870d80c536sq2fcr5q54sou887@4ax.com...
> > On Wed, 2 Mar 2005 16:21:03 +0100, "Simon Lidberg [MSFT]"
> > <simon***@online.microsoft.com> wrote:
> >
> >>In order for Windows Authentication to work you need to be in the same
> >>domain or at least a trusted domain, is this true in your case?
> >>If they are not in the same domain then you have to revert to SQL
> >>authentication.
> >
> > I am gueessing that we are in a trusted domain by the fact that
> > windows XP clients can connect with no problems from the same office?
> > Or is it that this may not be the case?
> >
> > Cheers,
> > Craig
>
>
>

Author
27 Jul 2005 3:18 PM
Ron Martin
We are having tha same issue here, only with XP clients. I can get in on my
XP desktop, another user can as well. Two other users using Windows XP,
through a 2way trusted domain, cannot get to the SQL server. No one enters
any names, just Windows service account.


Show quoteHide quote
"Mike Allen" wrote:

> I'm having same issue.  My XP client can connect to SQL using TCP/IP while
> 2000 can only connect with Named Pipes.  Both client computers are in same
> domain as the SQL server.  Any ideas?
>
> "Simon Lidberg [MSFT]" wrote:
>
> > Are the clients connecting to the the server using integrated security? Are
> > they connecting using the same network protocols?
> >
> > Simon
> > This posting is provided "as is" with no warranties and confers no rights.
> >
> > "Craig Pickles" <reply2cr***@hotmail.com> wrote in message
> > news:gt5e219f870d80c536sq2fcr5q54sou887@4ax.com...
> > > On Wed, 2 Mar 2005 16:21:03 +0100, "Simon Lidberg [MSFT]"
> > > <simon***@online.microsoft.com> wrote:
> > >
> > >>In order for Windows Authentication to work you need to be in the same
> > >>domain or at least a trusted domain, is this true in your case?
> > >>If they are not in the same domain then you have to revert to SQL
> > >>authentication.
> > >
> > > I am gueessing that we are in a trusted domain by the fact that
> > > windows XP clients can connect with no problems from the same office?
> > > Or is it that this may not be the case?
> > >
> > > Cheers,
> > > Craig
> >
> >
> >
Are all your drivers up to date? click for free checkup

Author
27 Jul 2005 3:31 PM
Mike Allen
My problem was with how Authentication was working between 2000 and Server
2003.  I just had to bump up the level of the LAN Manager Authentication
Level on my 2000 box from "Send LM & NTLM responses" to "Send LM & NTLM - use
NTLMv2 session security if negotiated".  This fixed my problem.

Show quoteHide quote
"Ron Martin" wrote:

> We are having tha same issue here, only with XP clients. I can get in on my
> XP desktop, another user can as well. Two other users using Windows XP,
> through a 2way trusted domain, cannot get to the SQL server. No one enters
> any names, just Windows service account.
>
>
> "Mike Allen" wrote:
>
> > I'm having same issue.  My XP client can connect to SQL using TCP/IP while
> > 2000 can only connect with Named Pipes.  Both client computers are in same
> > domain as the SQL server.  Any ideas?
> >
> > "Simon Lidberg [MSFT]" wrote:
> >
> > > Are the clients connecting to the the server using integrated security? Are
> > > they connecting using the same network protocols?
> > >
> > > Simon
> > > This posting is provided "as is" with no warranties and confers no rights.
> > >
> > > "Craig Pickles" <reply2cr***@hotmail.com> wrote in message
> > > news:gt5e219f870d80c536sq2fcr5q54sou887@4ax.com...
> > > > On Wed, 2 Mar 2005 16:21:03 +0100, "Simon Lidberg [MSFT]"
> > > > <simon***@online.microsoft.com> wrote:
> > > >
> > > >>In order for Windows Authentication to work you need to be in the same
> > > >>domain or at least a trusted domain, is this true in your case?
> > > >>If they are not in the same domain then you have to revert to SQL
> > > >>authentication.
> > > >
> > > > I am gueessing that we are in a trusted domain by the fact that
> > > > windows XP clients can connect with no problems from the same office?
> > > > Or is it that this may not be the case?
> > > >
> > > > Cheers,
> > > > Craig
> > >
> > >
> > >

Bookmark and Share