Unable to use Ent. Manager or Remote Desk. -
07-14-2004
, 09:51 AM
I have installed SQL Server on W2k3. The cluster works fine (this is for a
SharePoint 2003 deployment). However I am unable to connect to either
machine or the cluster DB from my workstation using Enterprise Manager or
Remote Desktop. Here are the relevant facts.
1. Both machines are on a different subnet from my workstation. I can
connect using EM and Remote Desk from any machine on the same subnet.
2. Before installing SQL server, I had Terminal Server running on both
machines. I could connect from my workstation. I removed TS in order to
install SQL server, per MS instructions. I then enabled Remote Desktop
Management on each machine.
3. Now I cannot use Remote Desktop or Ent. Manager. Moreover, I cannot ping
to either machine from my subnet. Tracert shows that the packets die at the
main switch to that subnet. I can ping from any machine on the subnet.
So, the only changes to the setup of the machines was to remove TS and
enable Remote Desk, and to install SQL server. Before, I could ping,
connect, etc. Now I cannot. However, it is not the machine that is causing
the problem, but the network switch.
One further note, name resolution for the cluster virtual machine and each
individual machine works (I can nslookup each name).
Is there something I have missed?
J. C. Willard
Sr. IT Architect
Virginia Department of Transportation |