Failed to log in SQL Server by using "sa" account.
The error code was 18456 which meant wrong password. But, I did input the right password. (If you are not sure about the password of "sa" , log in as any account which has "SysAdmin" role and change the password for "sa").
Sometimes, I got the error 233 which related to the client protocol. Based on the search results on google, I changed the order of client protocol in Sql Server Configuration Manager by setting TCP/IP before the NamedPipes.
But the above 2 solutions don't solve the problem. Actually, because the "Server Authentication" mode was set to "Window Authentication mode" only, that's why "sa" cannot log in.
So, after changing the authentication mode to "Sql Server and Windows Authentication" mode, it works fine.
The error code was 18456 which meant wrong password. But, I did input the right password. (If you are not sure about the password of "sa" , log in as any account which has "SysAdmin" role and change the password for "sa").
Sometimes, I got the error 233 which related to the client protocol. Based on the search results on google, I changed the order of client protocol in Sql Server Configuration Manager by setting TCP/IP before the NamedPipes.
But the above 2 solutions don't solve the problem. Actually, because the "Server Authentication" mode was set to "Window Authentication mode" only, that's why "sa" cannot log in.
So, after changing the authentication mode to "Sql Server and Windows Authentication" mode, it works fine.
No comments:
Post a Comment