June 29, 2011 at 10:07 am
Hello Everyone,
My application is trying to connect to the DB Server which in a different network behind firewall.
Some times I receive the following error in the log and the PROD server goes down.
Please help me in resolving the issue.
I have SQL Server 2008 Sp1 64 bit on Windows 2008 64bit
Error :
2011-06-28 09:30:18.89 Logon Error: 18456, Severity: 14, State: 38.
2011-06-28 09:30:18.89 Logon Login failed for user 'appvbdba'. Reason: Failed to open the explicitly specified database. [CLIENT: XXX.XXX.XXX.XX]
Profiler trace at that time gives this error on Audit login failure column.
Network error code 0x102 occurred while establishing a connection; the connection has been closed. This may have been caused by client or server login timeout expiration. Time spent during login: total 298930 ms, enqueued 0 ms, network writes 0 ms, network reads 0 ms, establishing SSL 0 ms, negotiating SSPI 0 ms, validating login 298930 ms, including user-defined login processing 0 ms. [CLIENT: XXX.XXX.XXX.XX]
Application: JTDS
Appreciate your inputs this is an urgent issue
Cheers,
Got an idea..share it !!
DBA_Vishal
June 29, 2011 at 10:26 am
The error message listed below seems to suggest the target database is not available.
You could check to see whether the default database assigned to 'appvbdba' is still available.
If it's not a default database problem, check the Profiler Trace for the database id / database name the ID is attempting to connect to, and verify if the database is available.
vkundar (6/29/2011)
Error :2011-06-28 09:30:18.89 Logon Error: 18456, Severity: 14, State: 38.
2011-06-28 09:30:18.89 Logon Login failed for user 'appvbdba'. Reason: Failed to open the explicitly specified database. [CLIENT: XXX.XXX.XXX.XX]
Let me know if this helps.
~Rusty
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply