How to apply MSSQL Patch/SP for DB in SAP System

SAP System
DB - MSSQL
OS - Windows Server


Straight and Simple:

1. Download the patch from SAP Service MarketPlace
2. Stop SAP using MMC
3. Stop DB using MS Visual Studio
4. Stop all SAP Services from service.msc
5. Stop all SQL Services from service.msc
6. Close MMC console
7. Close MS Visual Studio console
8. Drill down the installer for your OS/HW from the downloaded media, i.e. x64, x86, etc.
9. Double Click the installer
10. Let the installer check if any conflicting services are running or not
11. Complete the installation
12. Check DB/Bring DB online
13. Check SQL services/Start SQL services from service.msc
14. Start SAP services from service.msc
15. Start SAP using MMC

SQL Patching is done!

Check and confirm SQL patch number from MS Visual Studio.

Good luck!

Shival