SQL Server Authentication Problem

Posted on 2004-11-05
Last Modified: 2010-05-18
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.
Question by:duckcreektech
    LVL 18

    Expert Comment

    What edition of SQL Server do you have,  what service packs what operating system?
    LVL 6

    Expert Comment

    by:Duane Lawrence
    You need to isolate where the problem is.

    Go to the machine the database is running on
    Can you log in manually using that user id?

    Go to the remote machine.
    Can you log in manually using that user id?

    It sounds like the computer that is connecting to your database does not have the correct Active Directory setting.  You can give such in such networks or computers "trusted connection" status in Active Directory.  I can't help you do the Active Directory setting, but I am sure there is a group here that can.


    Author Comment

    It is SQL Server 2000 Standard running on Server 2000.

    I was able to Remote Desktop into the server, open up QA, and log in using the supportuser login.  So how do I set up trusted connection status on the server to allow other domain users?  Thanks.
    LVL 6

    Accepted Solution


    Author Comment

    I got it working.  Thank you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now