Announcement

Collapse
No announcement yet.

Can not connect to SQL 2008 R2 Server locally

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Can not connect to SQL 2008 R2 Server locally

    Hello,

    I am trying to connect to my SQL 2008 R2 STD 64 Bit locally via SSMS.
    The server is Windows 2008 R2 STD 64 Bit
    The server is on a Workgroup and NOT on a Domain.
    I am getting the following error:

    "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)"

    I configured what Microsoft suggested on its article as its Prefered option (Method 1):
    http://support.microsoft.com/kb/896861

    and Here:
    http://www.harbar.net/archive/2009/0...ould-know.aspx

    Only Option 2 works for me, but it is not suggested for Production environments.

    Any Help is appreciated.

    Thanks

  • #2
    Re: Can not connect to SQL 2008 R2 Server locally

    I guess that you have possibly 2 simultaneous conditions for this failure to happen:
    • SQL Server is not local (on another machine)
    • The trust is configured "Kerberos only"
    " DreaM is not what u saw in Sleep,
    DreaM is that which not let u Sleep "

    Life is Beautiful..!!!
    `.) Always
    `.(`.) Keep
    (`.). Smiling!
    `..
    Raj only raj

    Comment


    • #3
      Re: Can not connect to SQL 2008 R2 Server locally

      The OP states "connect locally"
      Tom Jones
      MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
      PhD, MSc, FIAP, MIITT
      IT Trainer / Consultant
      Ossian Ltd
      Scotland

      ** Remember to give credit where credit is due and leave reputation points where appropriate **

      Comment

      Working...
      X