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
askms
Member

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.