Intermittent Logon

Most of the time all the users can login to SQL.
On occation one or two will fail.
If I then try their login using Query Analyser it works...and then they are
able to log in.
What's going on?!?!?!
Kyle!
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:OJpLo7X0EHA.2016@.TK2MSFTNGP15.phx.gbl...
> Most of the time all the users can login to SQL.
> On occation one or two will fail.
> If I then try their login using Query Analyser it works...and then they
are
> able to log in.
> What's going on?!?!?!
Have you enabled failed login auditing on both the server and SQL Server?
Steve
|||When it fails what error do they see?
Rand
This posting is provided "as is" with no warranties and confers no rights.