28 Sept 2010

SQL SERVER 2005- Error 18452

SQL SERVER 2005- Error 18452: login failed for user ' sa'. The user is not associated with a trusted SQL Server connection.
This error happens when I login using windows authentication that was successed, but when I tried to login using SQL Server authentication that was failed following by error message



To fix this problem
Following next steps:
1. Login using windows authentication.
2. Right Click on server name >> select Properties >> Click on Security tab>> select SQL Server and windows authentication mode >> Ok >> Restart SQL Server (Click on server name >> select Restart >> Yes >> Yes)



3. Security>> Logins >> Click on ‘sa’login >> Right Click on it>> select Properties>> In General tab>> type password and confirm it >> Click on Status tab>> In Login select Enabled>> ok



Now, login using SQL Server authentication that will login.