Database Configuration – MS SQL SERVER

This topic has 2 replies, 3 voices, and was last updated 6 years, 4 months ago by Linus Betschart.

Creator

Topic
April 20, 2018 at 10:52 am #55680

Todd Perkins
Participant

Trying to configure a Database connection in the Database configurations. Currently running Cloverleaf 6.1.2 on AIX 7.1. It seems to be trying to connect as a local account on the server instead of using the AD credentials I’m entering. The SQL server I’m tring to connect to is 2012 running on Windows Server 2010.
Creator

Topic

Viewing 1 reply thread

Author

Replies
- May 21, 2018 at 2:53 pm #86142
  
  Daniel Murphy
  Participant
  
  I don’t think you can use AD credentials to connect to the SQL Server Database. I created SQL Authentication Accounts in my database server; assuming you have control over your particular SQL Server.
  
  I am using RedHat Linux 6.4 with Cloverleaf 6.1.3.
- May 22, 2018 at 7:25 am #86143
  
  Linus Betschart
  Participant
  
  If you are running your cloverleaf on Windows, you can run your “Infor Cloverleaf” service under a Windows domain account which has the rights to access your desired MS SQL database.
  
  Then, the database URL must be as follow:
  
  Code: jdbc:sqlserver://:;DatabaseName=;integratedSecurity=true
Author

Replies

Viewing 1 reply thread

The forum ‘Cloverleaf’ is closed to new topics and replies.