Where is the connection string for Monitor stored at?

• 
  Hi,
  
  Please read this article.
  
  Thanks,
  Priya

  priyasinha June 28, 2011 04:21

  - 0 +
• 
  I ran across that, but as you can see in below screen shot, I do not have a file named
  
  "RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config"
  
  i am on the correct server and i have "Show all files" turned on (so it's not hidden)
  
  searching for that file name brought back zero results too
  
  there is a "RedGate.Response.Engine.Alerting.Base.Service.exe.config" file in the install path I specified during setup, but no connection string info in there
  
  other ideas?
  
  
  

  sgilboy June 28, 2011 08:19

  - 0 +
• 
  Hi,
  
  That's very strange. I dont think that the base monitor service would have ever been able to start without this config file.
  
  The easiest would be to uninstall the Base Monitor on this machine and reinstall again. During installation, you would be able to then choose the correct database also. So you won't have to then change the connection string manually. You can find the base monitor installer in your web server install directory. This is the default location C:\Program Files\Red Gate\SQL Monitor 2\Web\WEBSITE\Download.
  
  Thanks,
  Priya

  priyasinha June 28, 2011 10:02

  - 0 +
• 
  Did you change the default installation location when you installed SQL Monitor? If so, the file might be in a different location.
  
  For example, on my production installation of SQL Monitor, it is in \ProgramData\Red Gate\SQL Monitor 2.
  
  Simon

  Simon L June 28, 2011 10:03

  - 0 +
• 
  Simon:
  
  I did install it on the G drive on the server, but there is no G:\ProgramData
  
  
  ah well, did the ol' "uninstall and reinstall" and I'm good now
  
  
  thanks guys

  sgilboy June 28, 2011 10:45

  - 0 +

Add comment

Please sign in to leave a comment.