Clovertech

Database Configuration – MS SQL SERVER

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Database Configuration – MS SQL SERVER

  • 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.