Not Associated with a trusted SQL Server connection

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • LMzizi
    New Member
    • Nov 2006
    • 8
    #1

    Not Associated with a trusted SQL Server connection

    Hi guys;
    I m trying to connect to server but this is the message I get

    "Login Failed for user 'sa'. Reason :Not Associated with a trusted SQL Server connection"

    pls guys help me I need to meet my due date next monday
    Tags: None
    • sashi
      Recognized Expert Top Contributor
      • Jun 2006
      • 1749
      #2
      Originally posted by LMzizi
      Hi guys;
      I m trying to connect to server but this is the message I get

      "Login Failed for user 'sa'. Reason :Not Associated with a trusted SQL Server connection"

      pls guys help me I need to meet my due date next monday
      Hi there,

      We need more information to solve the issue in return. The error message seems to be clear isn't it? I feel that you are not providing the correct "sa" / administrator password of the SQL server.

      Anyway, are you working in LAN? Are there more then one domain exist in your LAN? Please provide these details in order to get a fast & better respond. Good luck & Take care.

        Comment

        • LMzizi
          New Member
          • Nov 2006
          • 8
          #3
          Originally posted by sashi
          Hi there,

          We need more information to solve the issue in return. The error message seems to be clear isn't it? I feel that you are not providing the correct "sa" / administrator password of the SQL server.

          Anyway, are you working in LAN? Are there more then one domain exist in your LAN? Please provide these details in order to get a fast & better respond. Good luck & Take care.
          yes I'm using LAN and we have more than one domain

            Comment

            • sashi
              Recognized Expert Top Contributor
              • Jun 2006
              • 1749
              #4
              Originally posted by LMzizi
              yes I'm using LAN and we have more than one domain
              Hi there,

              I assume you are trying to connect to an SQL server of an untrusted domain, you need to ask your system administrator to enable domain trust relationship, hope it helps. Good luck & Take care.

                Comment

                • muzammilmansuri
                  New Member
                  • Feb 2007
                  • 1
                  #5
                  Originally posted by LMzizi
                  Hi guys;
                  I m trying to connect to server but this is the message I get

                  "Login Failed for user 'sa'. Reason :Not Associated with a trusted SQL Server connection"

                  pls guys help me I need to meet my due date next monday

                  Login failed for user; Reason: Not associated with a trusted SQL Server connection

                  Login failed for user "USERNAME-HERE." Reason: Not associated with a trusted SQL Server connection.

                  This error most commonly occurs when using SQL authentication, rather than Windows Authentication. There are a few reasons to use SQL authentication rather than Windows:

                  Client is not runnig a domain
                  Network contains PC's running Windows98
                  To enable both authentication protocols:


                  Go to Enterprise Manager.
                  Right Click on Server Name
                  Select Properties
                  Go to Security Tab
                  Set authentication to SQL Server and Windows

                  Hope this solves your problem

                    Comment

                    Previous template Next
                    Working...