Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: sql connection through vb

    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.

    thank you,

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    Sounds like you're using ODBC data source. Check the configuration on those workstations. Also, verify authentication rules on SQL server (Integrated, Mixed)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts