Windows Authentication Doesn't Work Locally I have a box running SQL Server 7 (I know) on Windows XP (I know).

All of the sudden, I'm unable to use Windows authentication to connect to the database from the local machine.

I can connect using SQL authentication on the local machine.

I can connect using both SQL and Windows authentication from another machine.

Here's the error I get when using Query Analyzer to connect to the local database using Windows authentication.



I've tried connecting using both the machine name, . and localhost.



Any ideas?

Thanks!

Update:  Added Screenshot of server protocols
I never figured out the root cause of the problem, but installing SQL Server 7 SP4 fixed the issue.