SQL Server Authentication Problem
Posted on 2004-11-05
I have a SQL Server login called supportuser on a server. The problem is that whenever I try to log in using this account (either through QA or C#) I get this error:
Unable to connect to server XXXX
Server: Msg 18452, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'supportuser'. Reason: Not associated with a trusted SQL Server connection.
Mixed Authentication IS enabled. I have checked this both through Enterprise Manager and through QA (I can log in using Windows Authentication). Everything that I have found either deals with Mixed Authentication or a guest account, neither of which help me. Does anyone have any ideas. Thanks.