- Instance info: Microsoft SQL Server 2017 (RTM-CU13) Standard Edition (64-bit) on Windows Server 2019 Datacenter
- Location: AWS
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.