Skip to Content
Author's profile photo Nilutpal Sharmah

MS SQL Upgrade from 2008 R2 to 2012 in SAP server.

Dear All,

Based on recent MS SQL upgrade project , today I am hereby tracking out all the required steps to upgarde MS SQL database of SAP server from 2008 R2 to 2012.

Platform details:-

1. SAP server : SAP BI with Netweaver 7.3 EHP1.

2. MS SQL : 2008 R2 (Version: 10.50.1702.00)

3. OS: Windows 2008 R2

Please check the pre-requisite of SAP-ABAP, SAP-BASIS, SAP-BW, kernel details as per note 0001676665 and 0001651862 . Based on NW 7.3 EHP1 SP6, I have kept dependent components in following stage:-

kernel : 720 UC – 402 (Extended)

SAP_ABA : Rel (731), Level (0006) [Minimum requirement is level 0003]

SAP_BASIS : Rel (731), Level (0006) [Minimum requirement is level 0003]            

One more pre-requisite is there that MS SQL 2008 R2 should be upgraded to SP1 or to later version. You can download the support pack  from based on your requirement like X64, IA64, X86 . After downloading the .exe file execute the file (Run as Administrator) . Please note that during upgrading database, stop all the SAP instance and MMC.

After completion of fulfilling all the pre-requisites, follow the below steps to upgrade database to MS SQL 2012 :-

1. Download the MS SQL 2012 database dump from SMP ( -> Database and Database Patches -> MS SQL Server -> Database -> then select the version and download with you S – ID)

2. Stop all the SAP instances.

3. Run  setup.exe (Application) available under ‘MS_SQL_2012R2\51046000\x86-x64\EnterpriseEdition’.

4. Select ‘Installation’ under SQL server installation Center and then click on ‘Upgrade from MS SQL 2005 or from MS SQL 2008’.

5. Then press NEXT till you end the upgrade. [During this operation, it will check whether required space is available or not in installation drive, so if it shows warning , then increase the size as per new requirement]

6. Once upgrade gets completed , run SWPM .

NB: You can download SWPM from ->Support Packages and Patches -> S -> ” SL TOOLSET” SL TOOLSET 1.0″ -> Entry by Component -> ” Software Provisioning Manager ” -> SOFTWARE PROVISIONING MGR 1.0 -> Windows server X 64 64 bit (as per my req.) -> Then download ‘Software Provisioning Manager1.0 SP2 for NW higher than 7.0x ‘ .

7. Select ‘Generic Installation Options’ -> ‘MS SQL Server’ -> ‘Database Tools’ -> ‘Database Upgrade Completion’  and execute.

8. Give profile location and password of SIDADM and click NEXT.

9. In case you get ‘database Connection issue’, please maintain following environmental variable in SAP server :-

dbs/mss/server= <local host name>

10. In case any issue appears , you can view the logs under “<Drive>:\Program Files\sapinst_instdir\GENERIC\MSS\DBTOOLS\MSS\YUP\. “.

11. After successful completion of upgrade and synchronization, start SAP instance from MMC and check the version of MS SQL in both SQL studio and SAP front-end  (System details).

I hope these steps would surely help most of SCNians.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Nilutpal,

      Many thanks for the detailed explanation provided, helpful for the many needful around.

      Thanks again..!!



      Author's profile photo Eduardo Rezende
      Eduardo Rezende

      Hi Nilutpal,

      Very detailed!



      Author's profile photo Former Member
      Former Member

      Hi Nilutpal,

      that is very helpfull.

      thank you for the detailed explanation.



      Author's profile photo Jon Brooks
      Jon Brooks

      It should be pointed out that after the upgrade of SQL Server, one should also apply both the x86 and x64 versions of the latest available service pack followed by the latest available cumulative update.