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

MSSQL Server USERS

Hello,

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.
0
rbunn
Asked:
rbunn
  • 2
1 Solution
 
rafranciscoCommented:
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.
0
 
rafranciscoCommented:
right-click on the server in Enterprise Manager, select Properties and go to the Security tab
0
 
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.
0
 
rbunnAuthor Commented:
Thanks  rafrancisco that worked perfectly!

-Rob
0

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