Problems connecting to SQL server on W2K3 from Win 2000 workstatio

We are running SQL Server 2000 on Windows Server 2003 (SP1 not installed).
We are trying to access our databases using Enterprise manager from our
machines in the office using windows authentication. We have no problems
from windows XP machines (using both TCP/IP and Named Pipes). I can connect
to the server using the SA account (TCP/IP) and Named Pipes from a windows
2000 workstation, but cannot access the SQL server from windows 2000 machines
using TCP/IP.

When we try to log in using windows 2000 we get "login failed for user
null". From xp machines it goes straight in.

Testing that I have done:
• Set up an alias to the Windows 2003 server name (SQL Server Client Network
Utility). No luck
• I can map a folder to the machine using net use command
• I am in the same AD domain.
• The clients are connecting to the server using integrated security (not
allowing SQL authentication)

I cannot understand what’s going on; do you have any pointers on where to
start looking?

Thanks



.

Relevant Pages

  • Re: Fileserver question
    ... >> another box running both 9.0 and Windows. ... >> computers in the same room and connected to a router. ... otherwise you will need to run a DHCP server on one ... > of the machines, preferably the server, or give both machines static ...
    (alt.os.linux.suse)
  • nslookup times out on some WinXP clients
    ... Basically, nslookup times out on some Windows machines, but not on others. ... we currently have a Windows 2000 Server DNS & DHCP Server serving IP ...
    (RedHat)
  • Re: New: LanMan98 V2 Not connecting
    ... all) Windows machines, the computer name as found in the system ... essentially Windows was rejecting the connection because it hadn't ... LanMan98 appears to be one, ... uses a low-level message protocol called SMB (Server Message Block). ...
    (comp.sys.acorn.networking)
  • Re: How do I see users that logged in ?
    ... - I know W98 machines should be migrated, but there are to many hindrances: ... Each subdirectory contains sub-subdirectories like administration, drawings, ... I know you can use the $ to share in windows, ... Can you log on to the server as user X and log on localy as user Y ??? ...
    (microsoft.public.windows.server.general)
  • Re: DST Updates - fun, fun
    ... Most XP machines received the daylight savingtimeupdate ... thesystemtimeis jumping ahead an additional ... all Windows XP, sp2 computers have been patched and verified. ... all Windows 2003 Server machines ...
    (microsoft.public.windowsxp.general)