Forum Discussion

Germain's avatar
Germain
Ideator III
23 days ago

Installation issue : ODBC Driver 18 SSL Provider error

Hello 😊

I'm trying to install Aras Innovation (all in one server for testing purpose)
and I'm stuck on this nice message while trying to connect to the DB :



Just to inform that my system is under :

  • Windows Server 2025 Datacenter Azure Edition (10.0)
  • IIS server version 10 (10.0.26100.32860)
  • .NET 6.0.36 installed
  • Microsoft SQL Server Express 2025 (17.0.1000)

 

☝️ And I've already pushed ODBC17/18 but without success regarding the install.


Thank you for your precious "lights" πŸ’‘

Regards,
G.

10 Replies

  • It is problem with SQL Service user. You need to give permission to sql user in the 'Manage user certificate'. 

  • Hi Germain,

    1. Run -> certlm.msc 
    2. Choose Server certificate -> Right click -> All Tasks -> Manage Private Keys
    3. Give permission to SQL Service user 
    4. Restart SQL service

    And try connecting to database

    • Germain's avatar
      Germain
      Ideator III

      Hello Kalaiselvan,

      I'm sorry but can't see the "Server certificate" to right click on...

       

  • Hello kalaiselvan and thank you for your help πŸ˜‰

    You mean from the "certmgr" ? if so, where should I give the permission on ?
    or should I create users "Innovator" (DB Owner) and "Innovator_regular" (DB Client) into SQL logins and give them permissions from the SQL Management Studio ?

    I'm not sure of "where to look at..." πŸ˜…

  • Hello,

    still stuck on this issue... 

    could anyone help or have any idea ?

    ps: is my "global settings" accepted for Aras solution ? :

    • Windows Server 2025 Datacenter Azure Edition (10.0)
    • IIS server version 10 (10.0.26100.32860)
    • .NET 6.0.36 installed
    • Microsoft SQL Server Express 2025 (17.0.1000)

    ?

  • angela's avatar
    angela
    Catalyst II

    Is "Force Encryption" Yes or No in your environment? 
    Is there anything in the second tab (Certificates)?

     

  • Hello,

    Can you please try uninstalling Microsoft OLE DB Driver 18 and install 19 and try Installing the ARAS