5 Replies Latest reply on Jan 29, 2019 3:50 PM by RealQuiet

    App Volumes Manager install issues, ODBC switching to SQL Server (10) Driver

    RealQuiet Novice

      OS: Server 2016 Datacenter

      AppVol: 2.14.0

      ODBC Driver: SQL Native Client 11.0

      SQL Server: 2012

       

      I am having an issue with a fresh install of App Volumes Manager. In advance I created the ODBC connection for svmanager using SQLNC 11.0 drivers and it connected successfully. The service account has dbo schema applied and db_owner permissions for the database on the SQL server.

       

      Attempt 1: Run the installer and enter the information to make the connection to the remote SQL server. Press browse for the database name and it fails with SSL error: Error 27502. Could not connect to Microsoft SQL Server 'server.fqdn.'. [DBNETLIB][ConnectionOpen (SECCreateCredentials()).] SSL Security error. (18)

       

      Attempt 2: Enter the database name, select overwrite existing, then Next. SSL error:  [Microsoft][ODBC SQL Server Driver][DBNELIB]SSL Security error :Error occured, error number:-2147467259Error location:Open DB

       

      Attempt 1 does not create an ODBC connection, however, Attempt 2 results in the installer overwriting the existing svmanger ODBC entry and replacing it with the SQL Server (10.0) driver. This fails due to SSL 3.0 and TLS 1.0 being restricted.

       

      Does anyone have advice on how to get App Volumes Manager to make this database connection? I tried the installer from App Volumes 2.14.0 and 2.14.2.

       

      Update:

       

      Attempt 3: I had the SQL admin provide an AD service account db_owner permissions and then made that service account an Administrator on the AppVol server. Logging in under the service account I was able to create an ODBC connection and successfully connect with the Integrated Windows authentication checked. I attempted AppVol install with the Connect using option set to Windows Integrated Authentication selected and received the same errors.