December 26, 2015 at 11:53 pm
My friends , I found an unusual problem with my software in last days , About two weeks before one of our applications which has been written with Borland Delphi 7 and uses ADO connection for connecting to Microsoft SQL Server 2005/2008 as Database Server stopped working fine .
In fact after each client starts the software and connects to the SQL Server database successfully Everything is going fine until the user stop working for a few seconds/minutes , Then when S/He come back to work an error message appears : Login failed for user ….. and So the user have to start the Application again until S/He could continue working .
We checked for Orphan SQL Server's users but we found nothing and even We checked the SQL Profiler but again found nothing useful .
The result of our tests is as following table : (Attachment Picture)
Please Help us and If you have any advice for our problem it would be very appreciated .
December 27, 2015 at 12:15 am
Ensure SQL Server's Facets is configured to audit login failures. Look at the SQL Server errorlog for the user's account, at the time when the login failed error is raised. Then see http://www.sqlservercentral.com/blogs/discussionofsqlserver/2013/04/18/getting-the-lowdown-on-18456-errors/
December 27, 2015 at 9:50 pm
Login failed for user usually means that your connection request was successfully received by the server name you specified, but the server is not able to grant you access for a number of reasons and throws error: 18456. To fix this problem you can take the help of following link: http://www.sqlserverlogexplorer.com/fix-microsoft-sql-server-login-failed-error-18456/
December 28, 2015 at 10:03 am
You might check to see if 'auto-close' is specified for the database.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply