Activity overview
Latest activity by pdolphin
Required permissions changed after upgrade
I have been running SQL Monitor 6 for some while using the permission setup as listed on the RedGate website https://documentation.red-gate.com/display/SM6/Permissions then I upgraded to version 7 ...
Required permissions changed after upgrade
I have been running SQL Monitor 6 for some while using the permission setup as listed on the RedGate website https://documentation.red-gate.com/disp ... ermissions then I upgraded to version 7 and ...
I could not find Install-Response.log anywhere so I just went ahead with the reinstall which did not work.
I deleted the existing database.
I try re-running the installer but it would not let me since I already had the version installed. It instructed me to uninstall the current version if I wanted to rerun the installer.
I un-installed the Base and Web programs.
I re-ran the installer and this time it started.
Since I had deleted the database I had to recreate it so I selected create database and I got an error in the "Set Up SQL Monitor database" dialog during the "Creating database..." that says:
Cannot assign a default value to a local variable.
Cannot assign a default value to a local variable.
Cannot assign a default value to a local variable.
Must declare the scalar variable "@MachinePos". But it does create a database! So I continued the install and it completed with no errors, both Base and Web were installed. BUT, when I go to the website I get the same error I initially got about the columns.
I have not received any email about a support ticket as of yet. / comments
I could not find Install-Response.log anywhere so I just went ahead with the reinstall which did not work.
I deleted the existing database.
I try re-running the installer but it would not let me si...
If you go to control panel and open programs and features what are the 2 version numbers given for the SQL Monitor Base and SQL Monitor Web. Do they match? are they both 6.0.5.5442?
Yes, they are both 6.0.5.5442
Do you have a backup of the data repository?
Sadly no. When I first set this up I was not sure I was going to like or use it so I did not configure the backups and apparently I never circled back to do so.
Not doing basic backups! I have brought shame to my family for generations.
Sounds like I don't have much choice but to delete the repository. Do I delete the entire RedGateMonitor database or just all the objects inside?
Lastly, any idea why this might have happened? Was it just a fluke or do I need to look into upgrading from SQL 2005 or Windows 7?
Thanks for the help. / comments
If you go to control panel and open programs and features what are the 2 version numbers given for the SQL Monitor Base and SQL Monitor Web. Do they match? are they both 6.0.5.5442?
Yes, they a...
Base Monitor Not Ready after upgrade
I just installed the most current update, which said it completed, but when I go to the website I get a page in BaseMonitorNotReady and get a message saying:
Unable to upgrade the Data Repository s...
Configure Clock Skew Alert
We are getting random Clock skew errors for VMs on the same host. We are trying to figure out why and it would be helpful if we could configure the Clock Skew alert to trigger after a 5 second dif...
Just what I was looking for, I just could not find it. Thanks so much for the help. / comments
Just what I was looking for, I just could not find it. Thanks so much for the help.
Can you configure a quiet time or black out time for monitor
My instance of SQL Server is on a VM, the network guy uses Veeam every Sunday to take a snapshot of the server and ship it to our backup location. This causes a whole slue of errors to spew out of...