• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1696
  • Last Modified:



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.
  • 2
1 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.
right-click on the server in Enterprise Manager, select Properties and go to the Security tab
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
rbunnAuthor Commented:
Thanks  rafrancisco that worked perfectly!


Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now