|| Rate this content|
Microsoft SQL Server 2008 R2 Software - Error "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication"
SQL Server returns the following error while try to connect from the client.
Microsoft Windows Server 2008 R2 Standard
System Type x64-based PC
System Model ProLiant DL360 G7
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)
Enterprise Edition (64-bit) on Windows NT 6.1 <X64>
(Build 7601: Service Pack 1)
SQL log :
2012-05-23 15:04:03.35 Logon Error: 17806, Severity: 20, State: 2.
The SQL server has been configured to operate in Windows Authentication Mode (Windows Authentication) and does not allow the use of SQL accounts.
Action plan :
Implement the workaround as per the following Microsoft KB article:
NOTE: One or more of the links above will take you outside the Hewlett-Packard Web site. HP does not control and is not responsible for information outside of the HP Web site.