Windows portion of Mixed Mode Authentication doesn't work

Schimelcat · #1 (**permalink**) 12-01-03, 16:54

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

Mincer · #2 (**permalink**) 12-01-03, 19:36

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

Matt.

Schimelcat · #3 (**permalink**) 12-02-03, 07:35

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

Quote:

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

Matt.