Activation fails - Connectionstring

[jhofstede]

We are trying to install Flexnet Manager Suite 2020 on a clean server.

When launching the Flexnet Manager Suite Activation Wizard, a problem occurs:

---Problem---

(s0m0): The activation wizard failed to initialize.

---System exception---

The ConnectionString property has not been initialized.

---Source---

System.Data

---Stack trace---

System.InvalidOperationException: The ConnectionString property has not been initialized.
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
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.Database.DatabaseConnection.Open()
at ManageSoft.Database.Impl.DatabaseLayerBaseSql.ConnectionOpen()
at ManageSoft.Database.Impl.DatabaseLayerBaseSql.GetScalarResult(CommandType p_CommandType, String p_CommandText, DatabaseParameter[] p_Parameters)
at Flexera.Broker.Connections.Impl.DefaultTenantActionsData.GetMultiTenancyStatus()
at System.Lazy`1.CreateValue()
at System.Lazy`1.LazyInitValue()
at ManageSoft.Activation.Executable.RunWizard()
at ManageSoft.Activation.Executable.Main(String[] args)

What I understand from the error message is that this has to do with the connection to the DB. I have not been able to find where the connection strings are stored and can be modified.

Hoping for some assistance.

[kclausen]

@jhofstede - This usually means that the Account that is being used to launch the Activation Wizard does not have access to the FNMS Compliance Database.

You need to run the Activiation Wizard using the FlexNet Manager Service Account that you have created.

[ChrisG · Accepted solution]

Alternatively, the "ConnectionString property has not been initialized" message may suggest that the Config.ps1 script has not yet (successfully) been executed to configure the FlexNet Manager Suite application server after installing the software.

Database connection string details (if configured) would appear in the registry in various entries under the key HKLM\SOFTWARE\Wow6432Node\ManageSoft Corp\ManageSoft\Reporter\CurrentVersion\.

[ImIronMan]

@ChrisG @kclausen 

We too faced a similar but slightly different error as shown below. We have FNMS 2020R1 On-Prem on Dev Environment. Can you please suggest a fix here

The app was running fine earlier. There has been few regular VM snapshots/DB backups were taken last night and after that this error occured. We restarted the web, batch and inventory servers as well but no luck. The fnms related batch jobs, services, sql agents, permissions on db's,IIS are remain unchanged and look fine.

We can also see the database connections strings are updated properly for all fnms databases in HKLM\SOFTWARE\Wow6432Node\ManageSoft Corp\ManageSoft\Reporter\CurrentVersion\.

[InvalidOperationException: The ConnectionString property has not been initialized.]
   System.Data.SqlClient.SqlConnection.PermissionDemand() +7139045
   System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection) +30
   System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +312
   System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +202
   System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +413
   System.Data.SqlClient.SqlConnection.Open() +128
   ManageSoft.Database.DatabaseConnection.Open() +536
   ManageSoft.Database.Impl.DatabaseLayerBaseSql.ConnectionOpen() +98
   ManageSoft.Database.Impl.DatabaseLayerBaseSql.GetScalarResult(CommandType p_CommandType, String p_CommandText, DatabaseParameter[] p_Parameters) +70
   Flexera.Broker.Connections.Impl.DefaultTenantActionsData.GetMultiTenancyStatus() +92
   System.Lazy`1.CreateValue() +470
   System.Lazy`1.LazyInitValue() +141
   Flexera.Web.Presentation.Resolver.AuthenticationResolverModule.Load(ContainerBuilder builder) +743
   Autofac.Module.Configure(IComponentRegistry componentRegistry) +109
   Autofac.ContainerBuilder.Build(IComponentRegistry componentRegistry, Boolean excludeDefaultModules) +139
   Autofac.ContainerBuilder.Build(ContainerBuildOptions options) +62
   Flexera.Web.Presentation.ResolverConfig.RegisterResolver() +731
   Flexera.Web.Presentation.MvcApplication.Application_Start() +170

[HttpException (0x80004005): The ConnectionString property has not been initialized.]
   System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +520
   System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +176
   System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +165
   System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +267
   System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +341

[HttpException (0x80004005): The ConnectionString property has not been initialized.]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +523
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +107
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +688

[kclausen]

@ImIronMan  - This KB Article may help.

https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/Reconnecting-to-a-new-database-when-it-has-been-moved-to-another/ta-p/152184