Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    29

    Unanswered: Not associated with a trusted SQL Server connection

    i'm connectin to an sql bd using a vb app. the app is running on 5 pc's with out any problems. but on 2 pc's i get the following message:

    -2147217843
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

    my sql sercity is set to authentication windows only.
    i tried setting it to sql and windows but i still got the same error.
    i switched back windows only and my app work on the pcs which it didn't work before. but after 30 min. of working i started to get the same error. i tried switching back and forth but it didn't help at all.

    please advise.

    thank you,
    thomas

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Could it be that PCs that the app is not working on have ODBC DataSource configured with Windows Authentication and the field Login ID contains SA while authentication method is selected to be Windows? Just a thought

  3. #3
    Join Date
    Sep 2003
    Location
    United States
    Posts
    65
    Provided Answers: 1

    is that system part of your LAN ??

    in addition to what rdjabarov say try this too

    just check whether that system is part of the domain and resgistered in your LAN.

    Also try to run commands like PING <<SQL Server's IP>> see what response u get.
    >>
    >> Learn PHP/MySQL for free https://www.youtube.com/watch?v=mpQts3ezPVg
    >> Free Web Hosting with PHP, MySQL, Website Builder : http://www.000webhost.com/862861.html

Posting Permissions

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