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

6
  • Are you sure that the SQL Server Service is running?
    – mrdenny
    Jul 1, 2014 at 17:30
  • Yes, it is definitely running. I can connect using SQL authentication, just not Windows authentication. Windows authentication works if I'm connecting FROM another machine.
    – Eli
    Jul 1, 2014 at 20:51
  • Has your password expired or something like that?
    – mrdenny
    Jul 1, 2014 at 23:19
  • My password hasn't expired. We've tried multiple Windows accounts and they all get the error. I even created a new local user on the box, gave it db access and it gets the error. The domain accounts with access all work as long as we're connecting to the db on HP00333198 from another machine.
    – Eli
    Jul 2, 2014 at 21:47
  • Can you post a screenshot of the protocols which are enabled for the server? The screenshot you have is the client network protocols.
    – mrdenny
    Jul 3, 2014 at 3:31

1 Answer 1

0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.