Cari Blog Ini

04 April 2013

Unable Connect To Server or Failed When Login for User 'sa'


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