Where is the connection string for Monitor stored at?

sgilboysgilboy Posts: 41
edited June 28, 2011 10:45AM in SQL Monitor Previous Versions
Today I moved (via detach/attach) the RedGateMonitor from one SQL instance to another

obviously that broke the product because the connection string is different now... looking in the website's "web.config" file, the connection string isn't set there.....

Where is it that I can reflect the move I did?

Comments

  • Hi,

    Please read this article.

    Thanks,
    Priya
    Priya Sinha
    Project Manager
    Red Gate Software
  • 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?


    yfnsj.jpg
  • 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
    Priya Sinha
    Project Manager
    Red Gate Software
  • 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 D:\ProgramData\Red Gate\SQL Monitor 2.

    Simon
    Red Gate
  • 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
Sign In or Register to comment.