How can we help you today? How can we help you today?
CraigPH
Using a fresh copy of our production environment, I tried installing the latest version of SQL Monitor.  The install failed as before when trying to start the monitoring service. Am getting the following when I try to start the monitor service executable directly. When I look in the folder, there is no file by that name - but there is a file named RedGate.SqlMonitor.Engine.Alerting.Base.Service.exe.settings.config So I tried copying that file and making a new one named RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config And I was able to start the monitoring service.  However, when I tried logging into SQL Monitor I got an error that the monitor was a different version from the web service, and suggesting that I download the base monitor installer.  I did that (and also removed the reference to the base monitor in the location.config file as specified by the error) but unfortunately it just gets me to the same place.  The folder again has a file named RedGate.SqlMonitor.Engine.Alerting.Base.Service.exe.settings.config instead of the correct name. If we cannot get a new version of the software installed, we may need to start looking at other options for monitoring our servers. 2021-08-05 13:07:01,234 [1] FATAL RedGate.Response.Engine.Alerting.Base.Service.Program - Unhandled exception System.IO.FileNotFoundException: Configuration file 'C:\ProgramData\Red Gate\SQL Monitor\RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config' not found    at RedGate.Response.Common.Persistence.ConfigurationFiles.GetAlertingServiceSettingsConfig()    at RedGate.Response.Engine.Alerting.Base.Service.Program.Main(String[] args)System.IO.FileNotFoundException: Configuration file 'C:\ProgramData\Red Gate\SQL Monitor\RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config' not found    at RedGate.Response.Common.Persistence.ConfigurationFiles.GetAlertingServiceSettingsConfig()    at RedGate.Response.Engine.Alerting.Base.Service.Program.Main(String[] args) 2021-08-05 13:07:01,281 [1] ERROR RedGate.Response.Engine.Alerting.Base.Service.Program - Unhandled exception System.IO.FileNotFoundException: Configuration file 'C:\ProgramData\Red Gate\SQL Monitor\RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config' not found    at RedGate.Response.Common.Persistence.ConfigurationFiles.GetAlertingServiceSettingsConfig()    at RedGate.Response.Engine.Alerting.Base.Service.Program.Main(String[] args)System.IO.FileNotFoundException: Configuration file 'C:\ProgramData\Red Gate\SQL Monitor\RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config' not found    at RedGate.Response.Common.Persistence.ConfigurationFiles.GetAlertingServiceSettingsConfig()    at RedGate.Response.Engine.Alerting.Base.Service.Program.Main(String[] args) 2021-08-05 13:07:01,312 [1] ERROR RedGate.Response.Common.Utilities.ErrorReporting.ErrorReporter - System.IO.FileNotFoundException: Configuration file 'C:\ProgramData\Red Gate\SQL Monitor\RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config' not found    at RedGate.Response.Common.Persistence.ConfigurationFiles.GetAlertingServiceSettingsConfig()    at RedGate.Response.Engine.Alerting.Base.Service.Program.Main(String[] args)System.IO.FileNotFoundException: Configuration file 'C:\ProgramData\Red Gate\SQL Monitor\RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config' not found    at RedGate.Response.Common.Persistence.ConfigurationFiles.GetAlertingServiceSettingsConfig()    at RedGate.Response.Engine.Alerting.Base.Service.Program.Main(String[] args)   Unhandled Exception: System.IO.FileNotFoundException: Configuration file 'C:\ProgramData\Red Gate\SQL Monitor\RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config' not found    at RedGate.Response.Common.Persistence.ConfigurationFiles.GetAlertingServiceSettingsConfig()    at RedGate.Response.Engine.Alerting.Base.Service.Program.Main(String[] args) / comments
Using a fresh copy of our production environment, I tried installing the latest version of SQL Monitor.  The install failed as before when trying to start the monitoring service.Am getting the foll...
0 votes
Hello...  I tried the installation on a fresh copy of production and it still fails.  I also tried running the executable that makes up the Monitor service directly, and I get the following...  not sure if any of this is useful: 2020-08-28 19:38:47,134 [    1] INFO  RedGate.SqlMonitor.Common.Logging.LogManager - Logging configured from file 'C:\Program Files\Red Gate\SQL Monitor\BaseMonitor\RedGate.SqlMonitor.Engine.Alerting.Base.Service.logging.json' 2020-08-28 19:38:47,437 [    1] FATAL RedGate.SqlMonitor.Engine.Alerting.Base.Service.Program - Unhandled exception System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for version: Could not load file or assembly 'RedGate.Response.Common.Utilities, Culture=neutral, PublicKeyToken=null'. The system cannot find the file specified. (C:\ProgramData\Red Gate\SQL Monitor\RedGate.SqlMonitor.Engine.Alerting.Base.Service.exe.settings.config line 5)    at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere)    at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)    at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)    at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)    at System.Configuration.Configuration.GetSection(String sectionName)    at RedGate.SqlMonitor.Engine.Monitoring.Core.LogRetrieval.ConfigurationFiles.GetAlertingServiceSettingsConfig()    at RedGate.SqlMonitor.Engine.Alerting.Base.Service.Program.ConfigureContainer(ContainerBuilder builder, CommandLineOptions commandLineOptions)    at RedGate.SqlMonitor.Engine.Alerting.Base.Service.Program.<>c__DisplayClass3_0.<CreateHostBuilder>b__0(ContainerBuilder builder)    at Autofac.Extensions.DependencyInjection.AutofacServiceProviderFactory.CreateBuilder(IServiceCollection services)    at Microsoft.Extensions.Hosting.Internal.ServiceFactoryAdapter`1.CreateBuilder(IServiceCollection services)    at Microsoft.Extensions.Hosting.HostBuilder.CreateServiceProvider()    at Microsoft.Extensions.Hosting.HostBuilder.Build()    at RedGate.SqlMonitor.Engine.Alerting.Base.Service.Program.Main(String[] args) Inner exception:    System.IO.FileNotFoundException: Could not load file or assembly 'RedGate.Response.Common.Utilities, Culture=neutral, PublicKeyToken=null'. The system cannot find the file specified.       at System.Configuration.TypeUtil.GetType(IInternalConfigHost host, String typeString, Boolean throwOnError)       at System.Configuration.MgmtConfigurationRecord.CreateSectionFactory(FactoryRecord factoryRecord)       at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere) End of inner exception: 2020-08-28 19:38:47,469 [    2] INFO  RedGate.SqlMonitor.Common.Logging.LogManager - Application ended / comments
Hello...  I tried the installation on a fresh copy of production and it still fails.  I also tried running the executable that makes up the Monitor service directly, and I get the following...  not...
0 votes
I apologize for the long delay, I got pulled into a project and this issue sort of slipped through the cracks again.   <configuration>   <configSections>     <section name="threadPool" type="RedGate.Response.Common.Utilities.ConfigurationElements.ThreadPoolSection, RedGate.Response.Common.Utilities"/>     <section name="version" type="RedGate.Response.Common.Utilities.ConfigurationElements.VersionSection, RedGate.Response.Common.Utilities"/>     <section name="networkSettings" type="RedGate.Response.Common.Networking.Configuration.NetworkSettingsSection, RedGate.Response.Common.Networking"/>     <section name="repositorySettings" type="RedGate.Response.Common.Persistence.ConfigurationElements.RepositorySettingsSection, RedGate.Response.Common.Persistence"/>     <section name="collectionSettings" type="RedGate.Response.Common.Persistence.ConfigurationElements.CollectionSettingsSection, RedGate.Response.Common.Persistence"/>     <section name="featureUsageSettings" type="RedGate.Response.Common.Utilities.ConfigurationElements.FeatureUsageSettingsSection, RedGate.Response.Common.Utilities"/>     <section name="debug" type="RedGate.Response.Common.Persistence.ConfigurationElements.DebugSettingsSection, RedGate.Response.Common.Persistence"/>   </configSections>   <debug fakeSchemaUpgrade="false"/>   <version number="1" versionstring="8.0.4.12548"/>   <threadPool minThreads="" maxThreads=""/>   <networkSettings portNum="7399"/> On a side note, I tried completely uninstalling SQL Monitor (base and web) and tried installing version 11 and I still get the same error. / comments
I apologize for the long delay, I got pulled into a project and this issue sort of slipped through the cracks again.  <configuration>  <configSections>    <section name="threadPool" type="RedGate.R...
0 votes