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
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.