Login failed for user '(null)'.

I'm running SQL 2000, SP3 on a W2K server and am having an issue where
users who are trying to connect to SQL Server via Windows Authenication
are getting a 'Login failed for user '(null)'. error. They have plenty
of permissions on SQL Server so that's not the issue. I've done some
testing and the only way I can get them to connect to SQL Server is if I
add them to the local admin group on the server. Has anyone else ever
seen this'
*** Sent via Developersdex http://www.developersdex.com ***Hi
Give the domain user permission to log into SQL Server.
Look at "user accounts, described" in BOL Index.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rachael Faber" <rfaber@.alldata.net> wrote in message
news:OZczaqUOFHA.2704@.TK2MSFTNGP15.phx.gbl...
> I'm running SQL 2000, SP3 on a W2K server and am having an issue where
> users who are trying to connect to SQL Server via Windows Authenication
> are getting a 'Login failed for user '(null)'. error. They have plenty
> of permissions on SQL Server so that's not the issue. I've done some
> testing and the only way I can get them to connect to SQL Server is if I
> add them to the local admin group on the server. Has anyone else ever
> seen this'
>
> *** Sent via Developersdex http://www.developersdex.com ***|||Hi Rachael,
Try to rejoin to domain some of the clients.
Regards,
Daniel
"Rachael Faber" <rfaber@.alldata.net> wrote in message
news:OZczaqUOFHA.2704@.TK2MSFTNGP15.phx.gbl...
> I'm running SQL 2000, SP3 on a W2K server and am having an issue where
> users who are trying to connect to SQL Server via Windows Authenication
> are getting a 'Login failed for user '(null)'. error. They have plenty
> of permissions on SQL Server so that's not the issue. I've done some
> testing and the only way I can get them to connect to SQL Server is if I
> add them to the local admin group on the server. Has anyone else ever
> seen this'
>
> *** Sent via Developersdex http://www.developersdex.com ***