January 25, 2013 at 1:14 pm
I just started a new DBA job and was introduced to SQL Monitoring from Red Gate. The program is not working like it should, the servers that are listed to be monitored have a status of "Monitoring Stopped incorrect credentials or insufficient rights" I already went through red gates instructions on how to check the connectivity and everything seems ok (http://www.red-gate.com/supportcenter/Content/SQL_Monitor/help/3.2/SM_Account_Permissions and http://www.red-gate.com/supportcenter/content/SQL_Monitor/help/3.2/SM_Testing_data_collection) . However, when I try to restablish the connection I see that the servers connect for a few seconds and then they go back to the same connection status. The account that I'm using is a network account like domain\username. Any other ideas of what it could be the problem?
Thanks.
January 28, 2013 at 2:08 am
Sorry to hear about the issue you have encountered in SQL Monitor. Could you please email me your Base Monitor log files at priya.sinha@red-gate.com? They should be in this \ProgramData\Red Gate\Logs\SQL Monitor 3 or equivalent location.
Thanks,
Priya
January 28, 2013 at 7:23 am
I just tried to restablished the connection and this is what was written to the log, please see below. One more thing that I believe is important and didn't mention before. We recentely change the way the sql red gate service is running. It used to run under our previous DBA's account, now it is running with the SQLServerUser.
[Red Gate Monitor (2.3.0.334), Running as: domain\SQLServerUser (Service), Working Dir: C:\Windows\system32]
[Running on: SERVERNAME (SERVERNAME.domain.local), OS Version: Microsoft Windows NT 6.0.6002 Service Pack 2, .NET Runtime Version: 2.0.50727.4234 (Microsoft)]
[Start Date: 2013-01-25 21:52:41Z, Current Date: 2013-01-25 21:52:44Z, Elapsed Time: 00:00:02.6553754]
2013-01-28 14:17:57,688 [ 5] WARN RedGate.Response.Engine.Monitoring.Core.New.DataCollectionScheduler - Overriding schedule for [Cluster].[SqlServer].[Database].[Table].[Index] with WeeklyJobSchedule(Sunday, 1, 0)
2013-01-28 14:17:58,812 [ 6] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\servername\HKEY_PERFORMANCE_DATA failed with error 5. Closing handle.
2013-01-28 14:17:58,846 [ 6] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\servername\HKEY_PERFORMANCE_DATA failed with error 5. Closing handle.
2013-01-28 14:17:59,254 [ 5] WARN RedGate.Response.Engine.Alerting.Base.Core.Email.SendMail - Sending email failed
System.Net.Mail.SmtpException: Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender
at System.Net.Mail.DataStopCommand.CheckResponse(SmtpStatusCode statusCode, String serverResponse)
at System.Net.Mail.SmtpConnection.OnClose(Object sender, EventArgs args)
at System.Net.ClosableStream.Close()
at System.Net.Mail.MailWriter.Close()
at System.Net.Mail.SmtpClient.Send(MailMessage message)
at (Object , MailMessage )
at #GVG.#IVG.#7VG(EmailSettings , String , IEnumerable`1 , String , NameValueCollection )
2013-01-28 14:18:04,793 [ 6] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\servername\HKEY_PERFORMANCE_DATA failed with error 5. Closing handle.
2013-01-28 14:18:05,024 [ 6] WARN RedGate.Response.Engine.Alerting.Base.Core.Email.SendMail - Sending email failed
System.Net.Mail.SmtpException: Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender
at System.Net.Mail.DataStopCommand.CheckResponse(SmtpStatusCode statusCode, String serverResponse)
at System.Net.Mail.SmtpConnection.OnClose(Object sender, EventArgs args)
at System.Net.ClosableStream.Close()
at System.Net.Mail.MailWriter.Close()
at System.Net.Mail.SmtpClient.Send(MailMessage message)
at (Object , MailMessage )
at #GVG.#IVG.#7VG(EmailSettings , String , IEnumerable`1 , String , NameValueCollection )
January 28, 2013 at 9:26 am
Hi,
If the permission has been set up correctly for this new user account then it shouldn't be a problem. Could I please get all the base monitor log files? The part of the log files which you have copied here is not enough to point to the problem.
Thanks,
Priya
January 28, 2013 at 10:42 am
Here's the log files.
January 29, 2013 at 7:21 am
One thing I want to mention is that when I ran all the tests listed in this page (http://www.red-gate.com/supportcenter/Content/SQL_Monitor/help/3.2/SM_Testing_data_collection) all work except the WMI. If I use my domain account it works but if I use the sqlserver account use to run the service it does not, it gives me the error "Number 0x80070005, facility win32, description Access is denied"
Any ideas how to fix this?
January 29, 2013 at 9:42 am
Hi,
I just had a look at the log files. The log is full with this error:
Not enough permissions on Data repository:Cannot open database "RedGateMonitor" requested by the login. The login failed.
Login failed for user 'domain\sqlserveruser'.
Does this new account has correct permission set up for RedGateMonitor database? You can find more information here: http://www.red-gate.com/supportcenter/Content/SQL_Monitor/help/3.2/SM_Account_Permissions
Also, if you are using this acccount to monitor too then please check that the account has correct permission on host machine and SQL Server too. Information on this page: http://www.red-gate.com/supportcenter/Content/SQL_Monitor/help/3.2/SM_Account_Permissions
Hope it helps. Let me know if you have more questions.
Thanks,
Priya
January 29, 2013 at 3:16 pm
I believe I got that error taking care of, now I'm able to login, however I cannot start the monitoring of the servers below it's what gets writting to the logs when I try to reestablish the connection.
2013-01-29 22:13:56,844 [ 22] WARN RedGate.Response.Engine.Monitoring.Core.New.DataCollectionScheduler - Overriding schedule for [Cluster].[SqlServer].[Database].[Table].[Index] with WeeklyJobSchedule(Sunday, 1, 0)
2013-01-29 22:13:57,719 [ 21] WARN RedGate.Response.Engine.Alerting.Base.Core.Email.SendMail - Sending email failed
System.Net.Mail.SmtpException: Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender
at System.Net.Mail.DataStopCommand.CheckResponse(SmtpStatusCode statusCode, String serverResponse)
at System.Net.Mail.SmtpConnection.OnClose(Object sender, EventArgs args)
at System.Net.ClosableStream.Close()
at System.Net.Mail.MailWriter.Close()
at System.Net.Mail.SmtpClient.Send(MailMessage message)
at (Object , MailMessage )
at #GVG.#IVG.#7VG(EmailSettings , String , IEnumerable`1 , String , NameValueCollection )
2013-01-29 22:13:57,881 [ 23] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\servername\HKEY_PERFORMANCE_DATA failed with error 5. Closing handle.
2013-01-29 22:13:57,920 [ 23] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\servername\HKEY_PERFORMANCE_DATA failed with error 5. Closing handle.
2013-01-29 22:14:05,960 [ 23] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\servername\HKEY_PERFORMANCE_DATA failed with error 5. Closing handle.
2013-01-29 22:14:06,176 [ 23] WARN RedGate.Response.Engine.Alerting.Base.Core.Email.SendMail - Sending email failed
System.Net.Mail.SmtpException: Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender
at System.Net.Mail.DataStopCommand.CheckResponse(SmtpStatusCode statusCode, String serverResponse)
at System.Net.Mail.SmtpConnection.OnClose(Object sender, EventArgs args)
at System.Net.ClosableStream.Close()
at System.Net.Mail.MailWriter.Close()
at System.Net.Mail.SmtpClient.Send(MailMessage message)
at (Object , MailMessage )
at #GVG.#IVG.#7VG(EmailSettings , String , IEnumerable`1 , String , NameValueCollection )
January 29, 2013 at 3:39 pm
If I play around with the email settings I get that function working properly. However, I still see the entry logs entered when I try to restablish the server connections to monitor my servers. The entry in the log is as follows:
Server A
2013-01-29 22:36:43,433 [ 11] WARN RedGate.Response.Engine.Monitoring.Core.New.DataCollectionScheduler - Overriding schedule for [Cluster].[SqlServer].[Database].[Table].[Index] with WeeklyJobSchedule(Sunday, 1, 0)
2013-01-29 22:36:44,046 [ 5] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\servername\HKEY_PERFORMANCE_DATA failed with error 5. Closing handle.
2013-01-29 22:36:44,126 [ 5] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\servername\HKEY_PERFORMANCE_DATA failed with error 5. Closing handle.
2013-01-29 22:36:51,512 [ 11] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\servername\HKEY_PERFORMANCE_DATA failed with error 5. Closing handle.
Server B
2013-01-29 22:46:01,822 [ 5] WARN RedGate.Response - Getting Log file
2013-01-29 22:47:07,601 [ 21] WARN RedGate.Response.Engine.Monitoring.Core.Licensing.LicenceAllocator - Licence level for serverB (1) changing from #a to #b
2013-01-29 22:47:07,625 [ 21] WARN RedGate.Response.Engine.Monitoring.Core.New.DataCollectionScheduler - Overriding schedule for [Cluster].[SqlServer].[Database].[Table].[Index] with WeeklyJobSchedule(Sunday, 1, 0)
2013-01-29 22:47:07,716 [ 5] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\serverB\HKEY_LOCAL_MACHINE failed with error 5. Closing handle.
January 30, 2013 at 4:53 am
Hello,
Thanks for your message. Are you still seeing issues when connecting to Monitored entity? Could you please send us screen shot of 'Monitored Entity' page showing the errors? The entries in the log files are all Warning so I wont be too concerned about it.
Thanks,
Priya
January 30, 2013 at 7:12 am
Attached are some images. I hope that gives you enough information.
January 31, 2013 at 2:32 am
Hi,
Thanks for the screen shot. Does the windows account running 'Base Monitor' service has administrative privileges on this particular host? Also, please could you also verify that 'Remote registry' service is running on this particular monitored entity?
Thanks,
Priya
January 31, 2013 at 7:05 am
The account does not have administraive priviledges on the machine. Also, how do I check for 'Remote registry' access?
February 1, 2013 at 6:17 am
Hi,
The account needs to have administrator rights on the host. Detailed permission is listed on this web page. Please make sure you have assigned these permissions correctly.
http://www.red-gate.com/supportcenter/Content/SQL_Monitor/help/3.2/SM_Account_Permissions
To check for 'Remote registry':
1. Go to Run and type 'Services.msc'.
2. This will open 'Services console'. Look for this service: 'Remote registry'.
3. Start the service if its not running.
Thanks,
Priya
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply