Connect to Local SQL Server 2014

[Former Member]

Dear all,

I have on my laptop a local SQL Server 2014 installed, and I would like to connect to that from Lumira. I have installed the JDBC drivers.

When I select SQL 2014 driver, I can specify for that one Windows Authentification, therefore I use the SQL2012 driver. 

Do you know which Server Name and Port I need to specify? I have added my connection details (TelcoData) which I can access without any problem from SAP PA but not from Lumira.

Any fsuggestion is more than welcome.

Philippe

[former_member198519 · Accepted solution]

Check this SAP Note: 2233344 - Lumira Desktop and Micosoft SQL Server JDBC Driver Compatibility

Install data access drivers: SAP Lumira 1.12 - YouTube

2181269 - Issue with Windows AD Connectivity from Lumira Desktop to SQL Server

have a look at the steps mentioned in the resolution:

- Click on the "Advanced" button, copy and paste the following line into the JDBC Driver Properties field:

integratedSecurity=true,authenticationScheme=NativeAuthentication