Slow Windows Authentication vs Fast SQL Authentication

When I run: osql -S 192.168.1.xxx -E -Q "sp_who2" it takes 47 seconds.
When I run: osql -S 192.168.1.xxx -U test -P password -Q "sp_who2" it takes
1 second.

The client is a web server that is in the DMZ connecting to a SQL 2000
server that is behind a firewall (NetScreen I believe) that only has TCP
port 1433 open and is doing NAT.

Any idea why Windows Authentication is so much slower than SQL
Authentication?

Thanks

Branden

Just a guess, but it may have something to do with the fact that you're
calling from the DMZ. Not being in the domain it may have to do a broadcast
to find the PDC for the auth. Again, just a guess.

"Branden" wrote:

> When I run: osql -S 192.168.1.xxx -E -Q "sp_who2" it takes 47 seconds.
> When I run: osql -S 192.168.1.xxx -U test -P password -Q "sp_who2" it takes
> 1 second.
>
> The client is a web server that is in the DMZ connecting to a SQL 2000
> server that is behind a firewall (NetScreen I believe) that only has TCP
> port 1433 open and is doing NAT.
>
> Any idea why Windows Authentication is so much slower than SQL
> Authentication?
>
> Thanks
>
> Branden
>
>
>
>
>