Red Gate forums :: View topic - SQL Monitor - can't connect
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

SQL Monitor - can't connect

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
blairtaylor



Joined: 06 Mar 2012
Posts: 1

PostPosted: Tue Mar 06, 2012 7:32 pm    Post subject: SQL Monitor - can't connect Reply with quote

We are evaluating SQL Monitor 2.3.0.334.

We set it up on our test web server. We are able to connect to the test DB on the same subnet without issue.

We are not able to connect to any of the production servers. We have tried both an sql server account (sa) and a windows account (administrator on the prod db machine). Both should not have permissions issues.

There is no firewall between the SQLMonitor web server and the production db hosts. We are able to connect via SSMS from the web server to to the production db hosts.

How can we diagnose this further? We took a look at the logs but there does not seem to be any error details.
Back to top
View user's profile Send private message
RBA



Joined: 05 Jun 2009
Posts: 148
Location: Cambridge

PostPosted: Wed Mar 07, 2012 4:57 pm    Post subject: Reply with quote

Hi,

SQL Monitor will try to connect from the machine running the 'base service' (which can be different from the one running the web app).

From the the machine hosting the SQL Monitor base service, see if you can ping the fully qualified domain name of the production server. If it doesn't resolve, SQL Monitor won't be able to see it either. If it does work, then ensure that access to each of the production machine's TCP/UDP ports is possible (for reference: this article on firewalls enumerates the ports that SQL Monitor requires open).

If you can fully access the production machine from the base monitor's host and can confirm that SQL Monitor is still failing when using the fully qualified domain name, then I would suspect that the user account SQL Monitor is running as (e.g. LOCAL SERVICE) is connecting to the production machine using an anonymous connection. In this case, you can override the machine credentials from the UI. Note that SQL Monitor needs both access to the OS and SQL Server, and these credentials can be separately overridden.

What is the error message in the UI when you try to add the production server in Configuration > Monitored servers?

Regards,
_________________
Robin Anderson
Development
Red-Gate Software
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group