![]() ![]() (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) This message occurs when using all kinds of I/O to the subsystem (which resides on the SAN). We tried with both username/password and MFA. I have no clue where to start investigating. Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. In regards to this specific error "Tcp provider error 0 - the semaphore timeout period has expired " this is a commonly caused by an intermittent network issue or SQL Server that is experiencing issues with hardware or being overloaded. ![]() ![]() In Unix environment, turn on ODBC trace and check thw system event log on MSSQLServer machine. This reduced the file count to around 500. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |