Connection Problem

  • Greetings

    I am trying to connect to a MSDE server on our network. The error message I get is "login failed for user 'sa', Reason: not associated with a trusted SQL Server connection.

    Can anyone give me some advice on what I need to do here?

  • What method/program you use to connect to your MSDE server?

  • I have tried with Query Analyser and Enterprise Manager same problem

  • Is the server using windows only authentication?

  • I have since discovered that the MSDE installs with windows auth by default. So I will reinstall with Mixed Mode enabled....

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply