Comments
4 comments
-
Hi,
I'm afraid I've not seen that particular error before but I suspect the firewall is the problem.
In order to monitor a server SQL Response needs both a SQL Connection (probably using port 1433 that you have open) but it also needs a WMI connection which uses DCOM. This intially uses port 135 for a connection but after that it can use other ports to carry on the communication.
http://msdn.microsoft.com/en-us/library/ms809327.aspx explains how you could get DCOM working across a firewall and how to restrict the pots it will use (however I'm afraid I've not tried any of this) -
Note - if these servers are accessable to the whole internet (via that firewall) then I would not recomend opening up the DCOM ports.
-
Can you establish a VPN to the servers and connect over the VPN (thus getting access to 1433 as well as 135, without exposing it to the internet)?
-
Setting up a VPN isn't something I have experience with.
If I get time I'll look into it.
Shame because the product is something that looked quite interesting.
The way I thought it would work would be that it would log things to a remote data base and the client would only need to be able to remotely access the database to retrieve the information.
Add comment
Please sign in to leave a comment.
I am trying to monitor 2 live servers that are not on our network (they are hosted by Rackspace). Both servers are SQL2005 on Windows 2003 server and are behind a firewall.
We have port 1433 allowed from our IP address to the remote servers and can connect remotely to the database servers using Management Studio etc.
Both remote machines are not on a domain and I have entered into SQL Response the correct local Windows user name and password for each machine. In the security tab in the event log on both machines I can see that it is managing to log in successfully with the supplied credentials.
SQL Response gives a "Computer Unreachable" error for both machines with the detailed error message being
WMI Error: The object exporter specified was not found (Exception from HRESULT 0x80070776)
Is there any required install for the remote machines, any required WMI version, any required services running or any required ports that need to be opened on the firewall?