Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010

    Unanswered: Login Incorrect error in SQL authentication mode

    I m using windows XP with sp2 running sql server. I have an accounts related software that uses sql db. Few days ago, i accidently deleted my database from enterprise manager. So I attached 3 days old backup of the db from another computer running its own SQL server. Now everything is working fine for me in windows authentication mode, but when i choose sql authentication mode, my software gives error message saying "login incorrect".
    And i really want to use sql authentication mode because i want a client to connect. Both Computers are in the same workgroup.
    Client was able to connect to SQLSERVER before i accidently deleted my db.
    Plzz help me to solve this problem...

    OR is there any way to connect the client with sever using windows authentication mode..

    Plzz Help!!

  2. #2
    Join Date
    Mar 2010
    Forgot to mention that i am using sql server 2000

  3. #3
    Join Date
    Aug 2004
    Dallas, Texas
    When you check the properties of this instance what is the authentication method on the security tab?

Posting Permissions

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