SQL Query Analyzer

  • Unable to Connect to server MyServer

    Srver: Msg 18456, Level 16 ,State 1

    [Microsoft][OBDC SQL Server Driver][SQL Server] Login failed for user 'sssss'. Reason: Not associated with a trusted SQL Server Connection.

    It gives me this error when i use login as 'sssss' and password as 'ddddd'

  • I suspect your SQL Server is set up for 'Windows Authentication' only, and you are trying to log on using SQL Server authentication.

  • I had this same problem a while back....somewhere in the log in settings theres an option that says something like

    "Use a trusted connection"....I think Ian is right though......use windows authentication and I think the problem will disappear....

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply