AnsweredAssumed Answered

Esri Integrator on Windows Server 2019

Question asked by C.Bold on Jul 21, 2020
Latest reply on Jul 22, 2020 by jyi

Attempting to install the Esri Integrator and the installation ends prematurely. There is not much in the way of error logging in the Log file produced. However in the Event Viewer Logs, we get this;

 

"Calling custom action OSIsoft.PIGeoServices.Setup.Actions!OSIsoft.PIGeoServices.Setup.Actions.CustomActions.VerifySqlRolesFirstInstallException thrown by custom action:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.OleDb.OleDbException: SSL Security error.
Invalid connection string attribute
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at OSIsoft.PIGeoServices.Setup.Actions.CustomActions.VerifySqlRolesFirstInstall(Session session)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture)
   at Microsoft.Deployment.WindowsInstaller.CustomActionProxy.InvokeCustomAction(Int32 sessionHandle, String entryPoint, IntPtr remotingDelegatePtr)
CustomAction VerifySqlRolesFirstInstall returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 17:18:06: VerifySqlRolesFirstInstall. Return value 3."
Any ideas?
OS: Windows Server 2019
Other Apps Installed: PI Vision 2019, PI Web API 2019, PI-to-PI Interface, AF client 2018 SP1
Not sure whats happening here.

Outcomes