SQL 2000 Access Problem

Results 1 to 2 of 2

Thread: SQL 2000 Access Problem

  1. #1
    Join Date
    Dec 1969

    Default SQL 2000 Access Problem

    I never had this trouble with MS SQL 7, but I received the following error from MS SQL 2000 running on Win 2000 Advanced Server:<BR><BR>"Login failed for user &#039;sa&#039;. Reason: Not associated with a trusted SQL Server connection."<BR><BR>Username "sa" always worked with SQL 7, but on SQL 2000, the default databases have the user "dbo" with the login "sa." However, the database I created, only has one user: "dbo" with no login name. I cannot edit this in any way. A friend said he had the same problem and so went back to SQL 7. But I would like to stick with SQL 2000. Can anyone tell me how to solve this? Thank you.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL 2000 Access Problem

    SQL Server was probally installed with using WIndows authenication, or Mixed mode.<BR><BR>It&#039;s trying to authenticate via Windows.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts