I am working for a critical account and yesterday I got a weird issue after applying cumulative update package 14 on top of SQL Server 2008 R2 Standard edition.
Before applying CU-14 package on the server, I stopped the DB Engine services from Configuration Manager. I started the patching and this finished successfully without any issue and I rebooted the machine too.
The thing is that Services were not coming online even if it was in automatic mode. I started the services and tried to connect and I got an error message:
Server is in script update mode
So I waited for some time because it is in
update in progress. After that when I connected to that instance I was getting
network related instance specific error
And interestingly SQL Server services was stopped automatically, again I was trying to start the services and the same scenario is happening repeatedly and I even uninstalled the CU-14 package from the server as well.
As a workaround I included "-T902" flag at the end of the parameters from config manager and started the services successfully and I am able to connect. But running the service by using the flag is not a good workaround.
Still I am experiencing the issue and please suggest: What are the steps we have to perform to resolve this issue?
Thanks for understanding!