February 13, 2016 at 1:03 am
Hello Team
Am encountering the below Error when i try to open one of the module in our ERP
" Cannot Open database " " requested lby the login. The login failed. Login failed for user sa"
This only happens to these specific database but other databases are working well.
We are using Sql server 2008 R2.
Kindly help
Regards
February 13, 2016 at 2:28 am
The login failed error message that SQL Server returns to the client is vague by design (to prevent hackers exploiting the information they are given).
You might find more information on the exact reason of the login failure by checking the errorlog around the time of the error. There might be more details recorded there.
If that does not help you, then you will have to set up a trace (extended events session if you're on SQL2012 or higher) to see what is going on when you start that ERP module.
With this type of problem, the solution is usually obvious once you know the cause.
Also, not really an answer to your question and perhaps something you cannot influence because it's baked into your ERP package but I am going to say it anyway: connecting to SQL Server on the sa user is a security risk and hence not recommend.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply