I am a newbie in Sql Server 2008 R2 Administration. Recently we migrated an Access database to Sql Server 2008 R2 DB. These users connect to Sql Server 2008 R2 database through Access using ODBC connections. Today I received few complaints that these users were being disconnected in the middle of their Access ODBC sessions while working on the SQL Server Database.
Can you please let me know what could be doing this? I do not have details of the error hence I am unable to provide them. But before anything, I just want to know is there a way in Sql Server to capture the Connection errors, users are facing or it can only be captured in Access?
We have a meeting tomorrow morning and I have to at least let them know if anything can be done from Sql Server end.