| Author |
Message |
EdCarden
Joined: 25 Nov 2008
Posts: 66
|
 Posted: Mon Jun 04, 2012 4:40 pm Post subject: Reconnecting automatically after monitoring stopped |
 |
|
The Redgate Help Doc titled "Reconnecting automatically after monitoring stopped - SQL Monitor" ( http://www.red-gate.com/supportcenter/Content/SQL_Monitor/help/3.0/SM_ReconnectAutomatically ) details the steps necessary to configure SQL Monitor to automatically attempt to reconnect when a failure to connect occurs. For us this happens ocassionally, usually when the system is down due to updates.
What the article does NOT tell you is what to do if that configuration file is NOT in the location specified in the article. The file to be edited is "RedGate.Response.Engine.Alerting.Base.Service.exe.settings" and according to the article its located at "C:\ProgramData\Red Gate\SQL Monitor 3\".
If like me you find the file is NOT in the location specified then you can find the files true location by examing another file in the same location specified in the article. If you open the file "RedGate.Response.Engine.Alerting.Base.Service.exe.config" in Notepad you will find a line detailing the actual location of the "RedGate.Response.Engine.Alerting.Base.Service.exe.settings" file.
Hopefully this will save someone else the time I wasted trying to do this because the article did not provide any suggestions or alternatives if the specified file is not in the location the article says it is. |
|
| Back to top |
|
 |
chriskelly
Joined: 19 Apr 2010
Posts: 252
Location: Cambridge, UK
|
| Posted: Tue Jun 05, 2012 10:53 pm Post subject: |
|
|
Thanks for your post.
While the configuration file "RedGate.Response.Engine.Alerting.Base.Service.exe.config" does contain the location of the configuration file "RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config", it is actually located in the directory C:\Program Files\Red Gate\SQL Monitor 3\BaseMonitor\ which is not the same location at all.
The directory C:\ProgramData\Red Gate\SQL Monitor 3\ is hidden by default on many machines, is slightly different for SQL Monitor 2 (as detailed in the document) and for pre-Win Server 2003 machines it is in the equivalent directory for that older directory structure.
However this is only not true when the user has made changes to the default install locations.
If there are any problems with making this configuration change then users should contact support@red-gate.com
_________________
Chris Kelly
Technical Support Engineer |
|
| Back to top |
|
|
EdCarden
Joined: 25 Nov 2008
Posts: 66
|
| Posted: Tue Jul 03, 2012 3:55 pm Post subject: Re: |
|
|
| chrisk5 wrote: |
Thanks for your post.
While the configuration file "RedGate.Response.Engine.Alerting.Base.Service.exe.config" does contain the location of the configuration file "RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config", it is actually located in the directory C:\Program Files\Red Gate\SQL Monitor 3\BaseMonitor\ which is not the same location at all.
The directory C:\ProgramData\Red Gate\SQL Monitor 3\ is hidden by default on many machines, is slightly different for SQL Monitor 2 (as detailed in the document) and for pre-Win Server 2003 machines it is in the equivalent directory for that older directory structure.
However this is only not true when the user has made changes to the default install locations.
If there are any problems with making this configuration change then users should contact support@red-gate.com |
Chris,
Since I did not make any changes from the default during the install of SQL Monitor does this mean I imagined fined the file ine the location I specified ? Just trying to get clarification on the conflicting statements, the differ3ence between where I found these files and where you say they actually were.
Thanks |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6346
Location: Red Gate Software
|
| Posted: Tue Jul 03, 2012 4:16 pm Post subject: |
|
|
Data files saved to "c:\program files" and "c:\program files (x86)" are automatically redirected to c:\programdata by Windows Vista, 2008, and Windows 7.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
EdCarden
Joined: 25 Nov 2008
Posts: 66
|
| Posted: Tue Jul 03, 2012 5:53 pm Post subject: Re: |
|
|
| Brian Donahue wrote: |
| Data files saved to "c:\program files" and "c:\program files (x86)" are automatically redirected to c:\programdata by Windows Vista, 2008, and Windows 7. |
Brian,
So then you are confirming my intial posts statement and confirming that the file is where I indicated and that Chris's reply was to state why the file is there instead of the location listed in the RedGate KB article and thats because Windows redirects the files to the progradata directory, correct?
Thanks |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6346
Location: Red Gate Software
|
| Posted: Wed Jul 04, 2012 9:28 am Post subject: |
|
|
The files won't be in c:\program files unless you are using an older version of Windows.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
Freman
Joined: 13 Sep 2012
Posts: 4
|
| Posted: Tue Oct 16, 2012 8:44 am Post subject: Re: |
|
|
Windows Server 2003 R2 Enterprise Edition:
C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Monitor 3
| Brian Donahue wrote: |
| The files won't be in c:\program files unless you are using an older version of Windows. |
|
|
| Back to top |
|
|
|
