After you install Microsoft SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005, or SQL Server 2000 and you try to connect to the server that is running SQL Server, you receive one of the following error messages:
- Login failed for user ‘%.*ls’. The login is a SQL Server login and cannot be used with Windows Authentication.%.*ls
- Login failed for user ‘<user_name>’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
- Login failed for user ‘<user_name>’. (Microsoft SQL Server, Error: 18456)
This problem occurs if the user tries to log in with credentials that cannot be validated. To resolve this issue, configure SQL Server in Mixed Authentication Mode. To do this, follow these steps:
- Open SQL Server Management Studio. To do this, click Start, click All Programs, click Microsoft SQL Server 20xx (where xx is the version of SQL), and then click SQL Server Management Studio.
- Right-click the server, and then click Properties.