Database Administrators Asked by Alonzo Hess on December 20, 2020
A Java app on another AWS server logs into the SQL instance using a local SQL account, and 95% of the time, the login connects, and everything is fine. The other 5% I get following error:
"Login failed for user ‘Blah.’ Reason: Failed to open the explicitly specified database ‘Blah_Database.’ [CLIENT: xxx.xxx.xxx.xxx]"
I know the 2 IP’s that the login request is coming from and the connection string names the database which is present. The permissions are set correctly.
I’ve captured the event running a Profiler Trace looking for Event Class "Audit Failed Login." But, This doesn’t give me any more info than the SQL error log.
Any other event classes I can add to the profiler to gather more info?
I’ve verified the the database Auto-Close feature is off. I’ve also increased the remote login timeout to 30.
@Alonzo, once it happened to me that we upgraded a software through a setup.exe file.
The installation was fine but because there was a load balancer involved the upgrade actually took place only on 4 databases out of 5. In the end 80% of our transactions were successful and 20% were failing for no reason.
It took us some time to understand that we had to manually apply that upgrade also on the 5th database.
So check if you find yourself in this scenario.
Answered by Francesco Mantovani on December 20, 2020
Perhaps AWS has some stuff similar to Azure Serverles' functionality? I.e., it takes a while to spin up the database. I would increase the connection timeout drastically as a first test and then take it from there.
Answered by Tibor Karaszi on December 20, 2020
1 Asked on February 4, 2021
2 Asked on February 3, 2021 by leona
3 Asked on February 2, 2021 by emanuele-paolini
1 Asked on January 31, 2021 by miguel-ramires
1 Asked on January 30, 2021 by milkncookiez
2 Asked on January 29, 2021 by chris-jenner
2 Asked on January 28, 2021 by stalinko
1 Asked on January 28, 2021 by thedemonlord
1 Asked on January 26, 2021 by elephantcoder
1 Asked on January 25, 2021 by rdrgtec
2 Asked on January 25, 2021 by dstr
2 Asked on January 24, 2021 by jac
1 Asked on January 23, 2021 by lloyd-thomas
1 Asked on January 18, 2021 by narendra
1 Asked on January 14, 2021 by din
1 Asked on January 14, 2021 by vince-kronlein
2 Asked on January 14, 2021 by nico-m
3 Asked on January 13, 2021 by roy-hinkley
Get help from others!
Recent Questions
Recent Answers
© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP