Apply To:
Microsoft SQL Server 2000
Problem:
* Could not login to SQL Server Query Analyzer using user login SA ( or System Administrator )
* Forget the password of user login SA
* Display warning
"Unable to connect to Server XXX:
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'sa'.
Description or screenshot of problem or warning:
Solution:
1. When login, choose option "Connect Using: Windows Authentication"
2. And you could access the SQL Query Analyzer
3. Then to reset password of user login 'SA',
go to menu "Start > Microsoft SQL Server > Enterprise Manager"
and choose Tab "Security > Logins"
4. Choose User Login Name : SA
then right-click, choose "Properties"
5. Go to column "Password", and type the New Password. Then click "OK"
6. Type again the Password in column "Confirm Password". Then click "OK"
7. Next, try again to login with user login name : SA
8. Now, the login with user name : SA is successfully
Source:
Andoko Chandra