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.
28 Sept 2010
SQL SERVER 2005- Error 18452
Posted by
Hayfa
Subscribe to:
Post Comments (Atom)
1 comments:
nice post, thanx for sharing
Post a Comment