External SQL

Has anyone had trouble using JDBC Drivers to connect to an external SQL server from IPA?

JDBC Driver:com.microsoft.sqlserver.jdbc.SQLServerDriver

Database URL: jdbc:sqlserver://SERVER:PORT;databaseName=

User and password were both tried with a local account and a domain account, getting "Login failed for user" but it does not seem to be related to actually logging in, creds work fine in ssms.

Thanks,
Nathan

Find more posts tagged with

Process Automation (IPA) - General Discussions

Comments

john-miller

Are you having this problem running on the Server, or from your designer (or both)?

Legacy Contributor

Both I figured my best troubleshooting steps would just be setting it up on the server, but I have tried IPD override configuration and a specific JDBC connection is sysconfig within landmark.

SQL Server 2014.

Legacy Contributor

Are you running MS SQL for your "main" system database, or are you using something else? Just wondering if you need to install the drivers on the server/designer.

Legacy Contributor

Landmark is currently on MS SQL

LSF is on Oracle

The external DB I am trying to connect to is MS SQL 2014

Legacy Contributor

If you access Infocenter search on "jars" a section Infor Landmark Technology Developer Guides / Infor Process Designer User Help / Configuring Connections make sure you have the jars reachable - location: LAENVDIR/install/jdbc

Legacy Contributor

The jars are currently reachable, not sure if they need to be updated.

russel-cornelson

For the record, the user that is configured in SQL Server ... this is a "SQL Server Authentication" user not a "Windows Authentication" user correct?

IPA JDBC can only leverage a SQL Server Authentication account.

bhillz

Is there any intention to move to Windows Authentication? Our security department has taken a keen dislike to server credentials (i.e. SQL Server Authentication).

Yes I know, they are easier to setup but if (or when) compromised, have greater consequences.

russel-cornelson

There are no plans to modify the SQL Query Node at this point. However, the thing I love most about Process Automation is flexibility. You could leverage the System Command node to make your SQL Queries using SQLCMD,

I wrote KB 1709978 to discuss this topic.

It references KB 1667935 which contains an example of a SQLCMD; it requires Landmark to be running as a Network Account. That network account works for a Windows Authentication user in SQL Server.

Copyright © 2025 Infor. All rights reserved.