Red Gate forums :: View topic - Reconnecting automatically after monitoring stopped
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Reconnecting automatically after monitoring stopped

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Mon Jun 04, 2012 4:40 pm    Post subject: Reconnecting automatically after monitoring stopped Reply with quote

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
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 329
Location: Cambridge, UK

PostPosted: Tue Jun 05, 2012 10:53 pm    Post subject: Reply with quote

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
View user's profile Send private message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Tue Jul 03, 2012 3:55 pm    Post subject: Re: Reply with quote

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
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6666

PostPosted: Tue Jul 03, 2012 4:16 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Tue Jul 03, 2012 5:53 pm    Post subject: Re: Reply with quote

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
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6666

PostPosted: Wed Jul 04, 2012 9:28 am    Post subject: Reply with quote

The files won't be in c:\program files unless you are using an older version of Windows.
Back to top
View user's profile Send private message
Freman



Joined: 13 Sep 2012
Posts: 6

PostPosted: Tue Oct 16, 2012 8:44 am    Post subject: Re: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group