i'm tring to connect to an sql db using visual basic. my app resides on many pc's over a local network. out of 6 pc's i have no problem connecting to the db through my app. but on 3 pc's i get the following error number and error description:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
is there some sort of rights that need to be applied to my db to allow the pc's to connect to the db.