Windows Authentication not working on WIN 2K workstation

[korzen]

Hi,

We recently upgraded a client machine to Windows 2000. Now, when attempting to access the server through OLE I get the old Login failed for user "(null)" error. SQL is set up for windows authentication, we are logging in as a domain user, and of course the users are set up as logins in SQL. This behavior happens for all windows users attempting to access SQL data from the machine in question. I've installed Connectivity Only from the SP Zero disk.

It seems that for some reason the windows username is not getting passed to SQL Server. SQL Server is running on NT4, so I thought maybe this was a cross-platform issue. Any ideas?

Thanks,

Chris Korzen
Boston, MA

 

[ClaireHCM]

Try this.

1. ping the server from that client machine and see whether the IP of the server is the right IP.

Then add the "real" IP to client network utility for alias.

2. make sure the the NT group that you added is not denied.