I'm hosting my web application on an azure VM. I've created a new user for MSSQLSERVER which my application can use to access the remote SQL server on that machine (so i do not use the sa user in my application). I have no problems at all accessing it, but i accidentally opened the Event Viewer and I found that each time I log into my application I get tens of messages that say
我在一个天蓝色的虚拟机上托管我的Web应用程序。我为MSSQLSERVER创建了一个新用户,我的应用程序可以使用它来访问该机器上的远程SQL服务器(所以我不在我的应用程序中使用sa用户)。我没有任何问题访问它,但我不小心打开了事件查看器,我发现每次登录我的应用程序时,我得到数十条消息说
"Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [client: ......]
“用户'sa登录失败'。原因:评估密码时出错。[client:......]
I first thought that it was an intruder, but then I realized that this message appears once I login to my application.
我首先想到它是一个入侵者,但后来我意识到,一旦我登录到我的应用程序,就会出现此消息。
Why could this message be shown ?
为什么要显示此消息?
1 个解决方案
#1
1
It is a state 1 issue, password validation gets done all-right, the problem is it is disabled for that user, in this case your MSSQLSERVER user or sa. Try logging in with sa, and log out to refresh credentials . grant all permissions to new user that you created, and log in with your newly created user. This should solve the problem [make sure that error number is either of 18470 or 18456].
这是一个状态1问题,密码验证完全正确,问题是它被禁用该用户,在这种情况下你的MSSQLSERVER用户或sa。尝试使用sa登录,然后注销以刷新凭据。授予您创建的新用户的所有权限,并使用新创建的用户登录。这应解决问题[确保错误编号为18470或18456]。
#1
1
It is a state 1 issue, password validation gets done all-right, the problem is it is disabled for that user, in this case your MSSQLSERVER user or sa. Try logging in with sa, and log out to refresh credentials . grant all permissions to new user that you created, and log in with your newly created user. This should solve the problem [make sure that error number is either of 18470 or 18456].
这是一个状态1问题,密码验证完全正确,问题是它被禁用该用户,在这种情况下你的MSSQLSERVER用户或sa。尝试使用sa登录,然后注销以刷新凭据。授予您创建的新用户的所有权限,并使用新创建的用户登录。这应解决问题[确保错误编号为18470或18456]。