Comments
Sort by recent activity
Hi Eddie,
Thanks for the guidance.
I Attached the Log Files to an email and sent them to Red Gate Support as requested.
We had a number of local security issues with the service account (<MyDomain>da_SQLDBATools) but the problems mysteriously cleared up after I asked Net Admin about them [image] So the logs will undoubtedly show a number of connection failures this morning. All of the other monitored servers are connected and responding as expected.
I also worked through the connection tests you asked about.
All of the connection tests except the WMI test worked fine. The WMI test returns the following error dialog:
Number: 0x800706b9
Facility: Win32
Description: Not enough resources are available to complete this operation
.
The target server is Windows 2008R2 Enterprise (64-bit) with 64GB RAM and 3 SQL instances (SQL 2008R2 Std, 64 bit, with SP3).
Based on following your links I concluded that memory might be the issue. I reduced the Max Server Memory for the 3 instances to 32GB, 4GB, and 4GB. Based on Perfmon, Available MBytes is now averaging 25,000 (i.e, 25GB). However, I still receive the WMI error.
FYI,
This past weekend was monthly database server maintenance and a number of things were updated (H/W and S/W).
The VM Host (Base Monitor and Web Server are on a VM) has upgraded memory.
Database servers applied Windows Updates, installed SQL2008R2 SP3, rebooted, etc.
Thanks. / comments
Hi Eddie,
Thanks for the guidance.
I Attached the Log Files to an email and sent them to Red Gate Support as requested.
We had a number of local security issues with the service account (<MyDomain>...
I uninstalled and re-installed the whole thing and it seems to be working now. / comments
I uninstalled and re-installed the whole thing and it seems to be working now.
Apparently part of the issue was the Domain accounts credentials. I reentered the password on the Service Account and the Base Monitor service started correctly.
However, I still have the information dialog on the Global Overview page that says "You are not currently monitoring any servers." even though the Monitored Servers page shows two servers and 4 instances. / comments
Apparently part of the issue was the Domain accounts credentials. I reentered the password on the Service Account and the Base Monitor service started correctly.
However, I still have the informat...
Hey Thanks for the reply.
I have a similar problem. 50K+ entries of SQL Error log for a failed disk ( fortunately on a Dev server:) / comments
Hey Thanks for the reply.
I have a similar problem. 50K+ entries of SQL Error log for a failed disk ( fortunately on a Dev server:)
linque wrote:
I'm an idiot. There is an option to check all alerts (not just the ones showing) that was right in front of my face the entire time. I'm good now. :oops:
Sure wish you'd said where the option is. I must have mud in my eye because I don't see it. / comments
linque wrote:
I'm an idiot. There is an option to check all alerts (not just the ones showing) that was right in front of my face the entire time. I'm good now. :oops:
Sure wish you'd said w...
I am confused by your post. Are you using TFS or Visual Source Safe? / comments
I am confused by your post. Are you using TFS or Visual Source Safe?
I could live with the auto-refresh if I could just figure out how to access the history to create custom reports.
I want to query the history directly to determine things such as how the duration, raw size, and compressed size of the t-log backups varies through the day.
I can query MSDB to get some of the information I need but right now the only way I see to get the Raw and Compressed size is to laboriously page through the constantly updating GUI which does not even sort in a useful order. I.e., if you sort by Type then the Date is unordered. If you sort by date, then the Full and Diffs are hard to find.
Direct, Read Access to the history database would solve this issue. / comments
I could live with the auto-refresh if I could just figure out how to access the history to create custom reports.
I want to query the history directly to determine things such as how the duration, ...
rayherring wrote: »
There must be something else that causes this error because I have assigned the new Service Account Full Control of the entire key from ..\BackupSettings down and I still see the error.
I am trying to change the SQL Backup Agent Service account. It is a member of SysAdmin fixed server role on the instance. SQL 2008R2 Standard on Windows 2008R2 Data Center.
It turns out account needs access to HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal as well. / comments
rayherring wrote: »
There must be something else that causes this error because I have assigned the new Service Account Full Control of the entire key from ..\BackupSettings down and I still se...
There must be something else that causes this error because I have assigned the new Service Account Full Control of the entire key from ..\BackupSettings down and I still see the error.
I am trying to change the SQL Backup Agent Service account. It is a member of SysAdmin fixed server role on the instance. SQL 2008R2 Standard on Windows 2008R2 Data Center. / comments
There must be something else that causes this error because I have assigned the new Service Account Full Control of the entire key from ..\BackupSettings down and I still see the error.
I am trying...
I don't mind sharing the files with Red Gate but I am not willing to post them on an open forum [image]
If you provide an email address I'll forward them to you as attachments or if you email a link I can upload them. / comments
I don't mind sharing the files with Red Gate but I am not willing to post them on an open forum
If you provide an email address I'll forward them to you as attachments or if you email a link I can...