How can we help you today? How can we help you today?
CraigPH

Activity overview

Latest activity by 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
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
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
Problem installing base monitor v10.1
I am attempting to install SQL Monitor 10.1 in our development environment - we are currently running 8.0.4During the install I get an error popup saying that the SQL Monitor Base Monitor service c...
3 followers 10 comments 0 votes
Which version of 9.x to use?
I am currently running SQL Monitor 8.0.4.1 I am getting a prompt that 9.2.2 is available.  However, when I log into the RedGate page and download the "latest version" it is giving me version 9.1.0A...
2 followers 2 comments 0 votes