Cannot connect to monitored machine

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Cannot connect to monitored machine

Postby BenKentzer » Tue Jul 13, 2010 12:47 pm

Hi

I'm running SQL Response 1.3.0.58, and have 3 server licences.

My repository is running on DOMAIN1, using an account in the local admin group (a DOMAIN1 account).

I am intending to monitor 3 servers.

2 of these machines are on a different domain, and are working fine using an account set up on the other domain to have the necessary access.

The third machine is on DOMAIN1, and the account running the repository has been added into the local admin group on the server to be monitored.
However, when I test the connectivity, the Windows side fails. The SQL Side succeeds, as the account is also a member of the sysadmin role directly on the server. However, because we cannot connect the Windows side, it won't allow us to monitor anything on the server.

I've tried another account for the Windows authentication (also a member of local admins - this time a local account) - still nothing.

We have another WMI monitoring solution which talks to all 3 servers successfully.

Any thoughts would be gratefully received.

Cheers

Ben
BenKentzer
 
Posts: 5
Joined: Tue Jul 06, 2010 12:23 pm

Postby eddie davis » Wed Jul 14, 2010 2:18 pm

Thank you for your post into the forum and sorry that you having problems with SQL Response.

Please right click the SQL Server you cannot connect to and select server properties.

Run the Test Credentials, when the test fails move the mouse cursor over the 'yellow warning triangle' and 'incorrect username password' message. A tooltip type message should appear with further details of the error. What is the tool tip message? Hopefully it will contain further information.

Also a support call has been created for you, the call reference number is F0036656. Can you please send an e-mail to support@red-gate.com, with the call reference number in the subject field with a copy of the Alert Repository Log file attached?

To locate the Alert Repository Log file, please click on the SQL Response icon in the very top left hand corner of the SQL Response Client immediately above the file menu ->Select the option to 'Copy Alert Repository Log file'.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests