Red Gate SQL Monitoring fails

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Red Gate SQL Monitoring fails

14 posts, Page 1 of 2

1 2 »»

Red Gate SQL Monitoring fails

Rate Topic

Display Mode

Topic Options

Author

Message

HildaJ

Posted Friday, January 25, 2013 1:14 PM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:11 PM
Points: 96, Visits: 268

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.

Post #1411914

priya.sinha

Posted Monday, January 28, 2013 2:08 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 8:44 AM
Points: 17, Visits: 62

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

Post #1412258

HildaJ

Posted Monday, January 28, 2013 7:23 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:11 PM
Points: 96, Visits: 268

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 )

Post #1412428

priya.sinha

Posted Monday, January 28, 2013 9:26 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 8:44 AM
Points: 17, Visits: 62

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

Post #1412500

HildaJ

Posted Monday, January 28, 2013 10:42 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:11 PM
Points: 96, Visits: 268

Here's the log files.

Post Attachments

Base Deployment 20130125.txt (1 view, 4.39 KB)

Base Deployment 20130125.log.1.txt (1 view, 15.30 KB)

Base Deployment 20130125.log.2.txt (1 view, 1.00 MB)

Base Deployment 20130125.log.3.txt (1 view, 1.00 MB)

Base Deployment 20130125.log.4.txt (2 views, 1.00 MB)

Base Deployment 20130125.log.5.txt (2 views, 1.00 MB)

Post #1412553

HildaJ

Posted Tuesday, January 29, 2013 7:21 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:11 PM
Points: 96, Visits: 268

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?

Post #1413037

priya.sinha

Posted Tuesday, January 29, 2013 9:42 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 8:44 AM
Points: 17, Visits: 62

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

Post #1413155

HildaJ

Posted Tuesday, January 29, 2013 3:16 PM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:11 PM
Points: 96, Visits: 268

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 )

Post #1413358

HildaJ

Posted Tuesday, January 29, 2013 3:39 PM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:11 PM
Points: 96, Visits: 268

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.

Post #1413364

priya.sinha

Posted Wednesday, January 30, 2013 4:53 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 8:44 AM
Points: 17, Visits: 62

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

Post #1413569

« Prev Topic | Next Topic »

14 posts, Page 1 of 2

1 2 »»

Permissions