Can not connect to SQL 2008 R2 Server locally Share on Facebook Post on reddit Tweet on Twitter Share on LinkedIn Home › Forums › Other Microsoft Servers and SaaS › SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2016 › Can not connect to SQL 2008 R2 Server locally This topic has 2 replies, 3 voices, and was last updated 9 years, 8 months ago by Anonymous. Viewing 1 post (of 1 total) Author Posts askmsMember May 31, 2011 at 1:36 am #154853 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/07/02/disableloopbackcheck-amp-sharepoint-what-every-admin-and-developer-should-know.aspx Only Option 2 works for me, but it is not suggested for Production environments. Any Help is appreciated. Thanks Author Posts Viewing 1 post (of 1 total) You must be logged in to reply to this topic.