Rarely occurring login issues in SQL Server are hard to explain when there is no significant load on the Instance or its host. A good idea for troubleshooting is using extended events, symbol files and the sysinternals tool, procmon. For some applications it is crucial to have a login timeout of less than 5 seconds….
Read More →