Knowledge Base

---

Article Summary: This article addresses an issue with SQL Server failed login attempts

---

Issue:

An error: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." when connecting to a SQL Server from a server or client computer using ODBC Data Souce Administrator (64-bit) and ODBC Data Souce Administrator (32-bit) or when attempting to open SQL Server Management Studio.

Solution:

1. Check the Login Properties for the Windows user account and ensure it has at least public access the the SQL Server.

a. Press Windows Logo+R, type ssms.exe to open SQL Server Management Studio.




b. Click the plus sign next to Security to expand it.

c. Click the plus sign next to Login to expand it.




d. Double-click on the account to open Login Properties and click the Server Roles under Select a page.




e. Under Server Roles ensure at least public is selected.

2. Use SQL Server Management Studio to change the Server authentication in Server Properties.

a. Press Windows Logo+R, type ssms.exe to open SQL Server Management Studio.

b. Click Connect to connect to the correct SQL Server.

c. Right-click the name of the server in Object Explorer and select Properties.

d. Click on the Security page under Select a page.



e. Under Server authentication click SQL Server and Windows Authentication mode to enable SQL Server and Windows Authentication mode.

f. Click OK to save the changes.

Additional Information:

This information applies to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL 2012.

Quick Tips content is self-published by the Dell Support Professionals who resolve issues daily. In order to achieve a speedy publication, Quick Tips may represent only partial solutions or work-arounds that are still in development or pending further proof of successfully resolving an issue. As such Quick Tips have not been reviewed, validated or approved by Dell and should be used with appropriate caution. Dell shall not be liable for any loss, including but not limited to loss of data, loss of profit or loss of revenue, which customers may incur by following any procedure or advice set out in the Quick Tips.