To expand a bit on the count(*) versus count(1) discussion, what does count(1) mean? 

The fact that count(1) returns the same value as count(*) is an artifact of the parser...

Early on in the development of the SQL:1999 ANSI & ISO standard, there was a concept of user-defined NULL types. The idea was to allow up to 128 different types...

I don't think it is quite accurate to say that COALESCE() has weaker type checking than ISNULL().  The semantics are different.  The type of ISNULL() is the type of the...

Thanks for all help.

I have made the SQL Server a domain controller, as noeld suggested, which has solved my immediate issue.

At some point, I will rebuild this SQL Server, or...

All client machines are WXP Pro with service pack 1 and the latest security patches.

I have tried creating the ODBC DSN at both the system and user level with the same lack of results.

The client OS is W/XP Pro, with service pack1 and all...

The ODBC  connection is configured to use Windows Authorization.

I agree that it is an issue with Windows credentials not being passed through, but I don't yet understand why.

I have logged...

The workstation used for keith is a member of the domain.