Forum Discussion

Germain's avatar
Germain
Ideator II
3 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.

Installation
SQL

4 Replies

  • kalaiselvan_np_nevs_com's avatar
    kalaiselvan_np_nevs_com
    Creator II
    2 days ago

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

  • kalaiselvan_np_nevs_com's avatar
    kalaiselvan_np_nevs_com
    Creator II
    2 days ago

    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 II
      3 hours ago

      Hello Kalaiselvan,

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

       

  • Germain's avatar
    Germain
    Ideator II
    2 days ago

    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..." πŸ˜