0

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.

Error Message

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

Client Network Settings

Any ideas?

Thanks!

Update: Added Screenshot of server protocols

enter image description here

Andriy M
  • 23,261
  • 6
  • 60
  • 103
Eli
  • 480
  • 5
  • 9

1 Answers1

0

I never figured out the root cause of the problem, but installing SQL Server 7 SP4 fixed the issue.

Eli
  • 480
  • 5
  • 9