Unanswered: Windows portion of Mixed Mode Authentication doesn't work
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:
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 !