SQL Server 2014 extended stored procedure gets stuck after Windows Server 2012 R2 updates
0
votes
0
answers
67
views
After running Windows Server updates (including server restart), SQL Server experienced problems executing XP_ commands. These are stuck forever without any response. The only solution I have found so far is to restart the SQL Server services, which is not appropriate in a productive environment.
The operating system is Windows Server 2012 R2 Standard and the database engine is SQL Server 2014 Standard
Is it possible that Windows Server updates are blocking these extended stored procedures from running?
There are no errors seen in the SQL Server logs related to the problem. I have checked the Windows Event Viewer events and have not found any indication of what may be happening either.
Until now, I have carried out the following actions without positive results:
1. I have updated SQL Server 2014 to the latest patch available today (5029185 Security update for SQL Server 2014 SP3 CU4: October 10, 2023).
2. I have installed a new instance of SQL Server 2014 on the same server, with the latest patches, but the problem is still the same. This makes me think that the problem is with the operating system.
As background, a SQL Server 2017 instance is installed on this same server, which has not been affected. Apparently the problem only affects SQL Server 2014.
Thank you all in advance for your answers or suggestions.
Asked by Victor
(1 rep)
Dec 28, 2023, 12:52 PM
Last activity: Dec 28, 2023, 02:24 PM
Last activity: Dec 28, 2023, 02:24 PM