Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    37

    Unanswered: Windows portion of Mixed Mode Authentication doesn't work

    Hey all,
    I've got SQL 2K running in mixed mode. I created a windows acct (mytest) in the administrator group, and then created a corresponding SQL account (mytest) using the windows authentication. In the EM it comes up as a "Windows User" type of acct. (The account is not a domain account but a workstation one).

    I've configured my app to use that account for access to the database but I get the following error message when I send the connection request to the datasource:

    Connection Failed:
    SQL State:28000
    SQL Server Error: 18456
    Login failed for user myworkstation\mytest

    I can connect just fine using the sql accounts, but it doesn't want to play nice when I need the windows authentication portion to work.
    What exactly am I doing wrong?
    Any input is greatly appreciated !
    Regards,
    Tammy

  2. #2
    Join Date
    Sep 2003
    Location
    London
    Posts
    56
    I think you've posted this in the wrong forum.

    Matt.

  3. #3
    Join Date
    Oct 2003
    Posts
    37
    Yeah, I realized that after a bit .... I tried deleting it but was told I didn't have "permission" ......
    maybe the forum gods will take pity on a stressed out db and delete it for me .....

    Tammy

    Originally posted by Mincer
    I think you've posted this in the wrong forum.

    Matt.

Posting Permissions

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