SQL Server Error Msg 49901 – The number of max worker threads that is configured %u is less than the minimum allowed on this computer. The default number of %u will be used instead. To change the number of max worker threads, use sp_configure ‘max worker threads’.

In this blog post, let’s learn about the error message “49901 – The number of max worker threads that is configured %u is less than the minimum allowed on this computer. The default number of %u will be used instead. To change the number of max worker threads, use sp_configure ‘max worker threads’.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

49901 – The number of max worker threads that is configured %u is less than the minimum allowed on this computer. The default number of %u will be used instead. To change the number of max worker threads, use sp_configure ‘max worker threads’.

Reason for the Error

To be update soon…

Solution

To be update soon…