question

manoj 2 avatar image
manoj 2 asked

SQL Server 2008R2

In SQL Server 2008R2 - which was working perfectly fine. Post windows update - it is giving below error in sql server error log - while starting sql server services.

2018-07-25 11:24:34.69 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Please do let me know what can be the issue here?

sql-server-2008-r2patching
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·

Was there anything in the SQL Server error log or the Windows event log about possible related problems?

1 Like 1 ·

2 Answers

·
manoj 2 avatar image
manoj 2 answered

Hi Thomas...Please find attached log with this.errorlog.txt


errorlog.txt (5.8 KiB)
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·

And have you done what was suggested on this line of the log?

The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x80090331. Check certificates to make sure they are valid

0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered

It looks as though there were some issues in the latest round of Windows patches. The article here gives a list of affected patches and patches which have been, erm, patched...

https://blogs.msdn.microsoft.com/psssql/2018/07/26/july-10-2018-windows-updates-cause-sql-startup-issues-due-to-tcp-port-is-already-in-use-errors/

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·

Drat... I was coming back to the post to mention that link...

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.