Posted on 2005-05-11
Last Modified: 2008-02-01

I have a SQL server running,  and most of the users are connected through their NT Login.

I need to add a couple of users that are not on the NT domain.

say "Rob", for instance.

I have added the User to the SQL server Enterprie Manager,  with SQL Server Authentication rather then Windows Authentication.

but I am unable to connect to this database via ODBC.
it just keeps giving me the error
Connection failed:
SQLState: '28000'
SQL Server Error: 18542
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'ROB'. Reason: No associated with a trusted SQL Server connection.

any help is greatly appreciated.
Question by:rbunn
    LVL 28

    Accepted Solution

    Also make sure that your SQL Server also accept SQL Server Authentication.  To check if it accepts SQL Server Authentication, right-click on the server in Enterprise Manager and go to the Security tab.  Make sure that the SQL Server and Windows Authentication is selected.
    LVL 28

    Expert Comment

    right-click on the server in Enterprise Manager, select Properties and go to the Security tab
    LVL 44

    Expert Comment

    by:Vitor Montalvão
    That's not a SQL Server problem, but ODBC.
    For that users you need to change ODBC's connection string. I bet that ODBC is configured for trusted connections, but now you need to change it to accept SQL Server logins (add Username and Password to the connection string).

    Good luck.
    LVL 1

    Author Comment

    Thanks  rafrancisco that worked perfectly!


    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.

    Join & Write a Comment

    Introduction: I have seen many questions on EE and elsewhere, asking about how to find either gaps in lists of numbers (id field, usually) ranges of values or dates overlapping date ranges combined date ranges I thought it would be a good …
    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    754 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

    14 Experts available now in Live!

    Get 1:1 Help Now