Hi Team,
we have installed Flexera 2022R1 version and try to run the reconcilation job. but its failing immediately with below error.Please help me its urgent.
023-06-30 02:00:11,112 [INFO ] Running Compliance import command line: '-processremotepackages true -it ReadersAndWriters'.
2023-06-30 02:00:11,487 [INFO ] Time: Friday, June 30, 2023 2:00:11 AM
2023-06-30 02:00:11,487 [INFO ] FlexNet Manager Platform
Version 18.0 rev 24 build 0
Copyright 2022 Flexera Software LLC
2023-06-30 02:00:12,159 [INFO ] No intermediate path specified, using default output path E:\ProgramData\Flexera Software\Beacon\IntermediateData.
2023-06-30 02:00:15,112 [INFO ] Enter ReadLicense
2023-06-30 02:00:18,847 [INFO ] Enter ProcessLicenseFile FNE LicenseBuilder
2023-06-30 02:00:18,878 [INFO ] Exit ProcessLicenseFile FNE LicenseBuilder
2023-06-30 02:00:18,894 [INFO ] Exit ReadLicense
2023-06-30 02:00:20,082 [INFO ] Did not find an importer xml file in folder 'C:\ProgramData\Flexera Software\Compliance\ImportProcedures\ObjectAdapters\'. Only procedures loaded from previous folders will be used.
2023-06-30 02:00:20,082 [INFO ] Performing import
2023-06-30 02:00:20,925 [INFO ] Importing from 'FlexNet Manager Suite' [type: ManageSoft] (primary connection)
2023-06-30 02:00:20,925 [INFO ] Running Compliance import with "-processremotepackages true -it ReadersAndWriters" parameters
2023-06-30 02:00:21,660 [INFO ] The impersonated user is 'CORP\sv-Flexera1-p'.
2023-06-30 02:00:21,894 [ERROR] ManageSoft.Compliance.Importer.Logic.ComplianceReaderFatalException: Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
There is a possible connection type mismatch: check that the database is of the correct connection type ---> System.Data.SqlClient.SqlException: Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
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.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at ManageSoft.Compliance.Importer.Logic.DatabaseConnection.Open()
at ManageSoft.Compliance.Importer.Logic.DatabaseSourceConnection.GetVersionReader(String versionQuery)
at ManageSoft.Compliance.Importer.Logic.DatabaseSourceConnection.ReadVersion(String versionQuery)
at ManageSoft.Compliance.Importer.Logic.DatabaseSourceConnection.CalculateVersion(ReaderConfig sourceDataType)
--- End of inner exception stack trace ---
at ManageSoft.Compliance.Importer.Logic.DatabaseSourceConnection.CalculateVersion(ReaderConfig sourceDataType)
at ManageSoft.Compliance.Importer.Logic.ActionExecuter.ReaderExecuter.Execute()
at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ProcessExecution(ComplianceReader p_ComplianceReader, Tenant p_Tenant, IExecutionContext p_Context)
2023-06-30 02:00:22,582 [INFO ] Released application lock ManageSoftComplianceImporter_Exclusive
2023-06-30 02:00:22,582 [INFO ] Time: Friday, June 30, 2023 2:00:22 AM
2023-06-30 02:00:22,597 [INFO ] Total import time: 10 seconds
2023-06-30 02:00:22,597 [INFO ] 0 source data warnings
2023-06-30 02:00:22,597 [INFO ] 1 errors, 0 warnings
