I need to manually deploy some SQL patches
We have some machines that are in need of some SQL patches that I can't get to succesfully download via WSUS. It either sees the patches as not necessary and doesnt spool them out or it is unsuccessful in installing them. To be honest I am not received any error messages from my servers to indicate that there are problems with SQL but our auditors insist that we have these installed. I know it can be done but I am fairly new to KACE other that reporting and have taken over this for the person who left. Anyway all help will be appreciated.
Answers (3)
If you are wanting to use Kace you will need to navigate to Security>Patching>Patch Listing. You will then need to create a patch label. The one below is an example.
You will then go to "Detect and Deploy" and create a patch schedule. This screen is somewhat self explanitory. Add your patch label you just created, and the machines/machine labels you want them deployed to. At the bottom you can set the schedule.
Here are some Kace KKEs that can help explain this a little better.
K1000 KKE's: https://support.software.dell.com/k1000-systems-management-appliance/kb?k=KKE
Comments:
-
AWESOME!!! Thanks this should do it! - alongerbeam 11 years ago
-
I forgot to add make sure your subscription settings are set to download patches for your servers.Those videos will explain that a little more. - dugullett 11 years ago
You could have a corrupted patch on these servers. Stop the windows update service and background intelligent transfer service. Go to c:\windows\softwaredistribution\download and delete all the files and directories in there. Restart the services and at the command prompt type wuauclt /detectnow. This will clear any updates installers and reaquire them.
Can you manually download the patch as an MSI (or MSP)? If so, then deploying it through KACE as a Managed Install is rather easy.
Comments:
-
Yes I have thought of that and planning on giving it a try. - alongerbeam 11 years ago
