Unable to connect to MS SQL Server 2012

[Former Member]

H
I am trying to connect to SQL server from Lumira using Free Hand SQL Datasource.

When I connect using JDBC (4th gen) driver I get error

"Driver error:Login failed for user 'user'.client connectionid: xyz....."

I checked TCP/IP is enabled and Windows and SQL Server Authentication mode is selected.

Your help will be highly appreciated,

Thanks,

[shankarsgs]

Hi David,

Are you using the right driver for your SQL. If not please download the sql drivers and install them SAP Lumira. You can also try creating a new user and try logging in using that user. If above does not work let us know, We can try other alternate ways to figure out the issues.

Regards

Shankar

[Former Member]

Shankar,

I have latest driver and tried creating another user to no avail.

[Sriram2009]

Hi David

Have you check this SAP video clips?

SAP Lumira 1.12.0: Install data access drivers

BR

SS

[shankarsgs]

Hi David,

Can you please share the screen shot of the error you are getting in Lumira.

Regards

Shankar

[achab]

Hi David, is it an option you can try with another client tool? (like Universe Design tool or Information Design tool) Besides this idea, does your authentication work when connecting in SQL Server Management Studio for instance? It seems your login does fail.

Best regards

Antoine

[Former Member]

This message was moderated.