2534024 - Unable to connect to SQL Server 2012 from Lumira Desktop

• Attempting to connect to Microsoft SQL Server 2012 results in the error message:
  com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more recent version of the Java Runtime (class file version 52.0), this version of the Java Runtime only recognizes class file versions up to 51.0

• SAP Lumira Desktop 1.31.x
• Microsoft Windows
• Microsoft SQL Server 2012

1. In Lumira Desktop click on File > New
2. Select "Query with SQL"
3. Click on the MS SQL 2012 driver
4. Enter Database details
5. Click Connect

• SAP Lumira uses SAP JVM 7 (Java Virutal Machine), Lumira needs to be pointed to Java 8 in order for this driver to run successfully

1. Edit C:\Program Files\SAP Lumira\Desktop\SAPLumira.ini in notepad or other text editor
2. At the very top of the file add these lines (note they should be two separate lines):
   -vm
   C:\Program Files\Java\jre1.8.0_31\bin

Please note:

• The path most likely will be different depending on the install and version of Java installed on the machine.
• Save the file and start Lumira.
• On install of a patch the SAPLumira.ini will be overwritten and this fix will need to be applied again.

KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem