User Logon Failed. This user is not associated with a trusted SQL Server connection. Error: 18452, sql18452
After installing SQLServer2005 (or the SQLServer2005 that comes with Visual Studio 2008), you can use SQL Server authentication to log on to the Server. Sometimes this occurs:
The cause of this error is that when SQL Server is installed, the logon mode is restricted to Windows authentication. Therefore, an error occurs when a specific user logs on. The solution is as follows:
1. After using Windows authentication, right-click the attributes of the login server.
2. Select "security" to set "Server Authentication" to "SQL Server" and "Windows Authentication mode.
3. Restart the service. OK!
User Logon Failed. This user has no connection to the trusted SQL Server. Error: 18452
1. log on to sqlserver2005 with a windows Account
2. Right-click the top root directory on the left. properties. (server properties)
3. a) Select security first.
B) Select SQL Server and Windows Authentication Mode
4. Change sa Password
5. Restart the service
User 'sa 'login failure this user is not associated with a trusted SQL Server connection (microsoft SQL Server, Error: 18452 ))
During installation, select 'hybrid logon mode'
Solution,
After logging on to the Windows authentication method,
Select database engine, right-click Properties, and on the "Security" tab, under "authentication", select "SQL Server and Windows"