rbunn
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
right-click on the server in Enterprise Manager, select Properties and go to the Security tab
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.
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.
ASKER
Thanks rafrancisco that worked perfectly!
-Rob
-Rob