Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Remote desktop: the computer can't connect to the remote computer

Posted on 2008-10-07
3
2,731 Views
Last Modified: 2013-11-21
Hello,

Yesterday a third party upgraded our sql 2000 database to sql 2005. No problem at all but they connected to our webserver. Once connected they connected through rdp to our sql server and did the upgrade. But after the necessary restart of the sql server they couldn't connect to it anymore. I've tried it also from home through Citrix and once logged in through rdp. I couldn't reach it as well. This morning I've tried to login locally and this worked gladly. I've searched throug EE but I couldn't find my answer. Hopefully some of you guys/girls could help me.

I can reach the sql server by typing in explorer \\servername\c$, it prompts me for my admin credentials and I can reach the c partition then.

I can ping it from clients or another server.

I can connect remotely to it's services from another server of client.
Windows firewall is off.
I have 2 draytek firewalls on the edge of my network and behind that 1 ISA server 2004. Behind that you find our servers. So I don't thinks it's a firewall problem because it worked before the upgrade.

I've re-installed the rdp client on the sql server but it didn't work.

I can however connect from my sql server to other servers/clients in my network through rdp. (offcourse I am logged in locally on my sql server then)

When I try to use rdp, it prompts me for my username and password. But when I type it in I get this message: Remote desktop: the computer can't connect to the remote computer

I also disabled and re-enabled remote desktop on the sql server but still it doesn't work.

I hope you have more good suggestions.

Thnx in advance




0
Comment
Question by:KNBsysteembeheer01
  • 2
3 Comments
 
LVL 2

Expert Comment

by:Ron9909
ID: 22659912
I know that SQL 2005 is not supported on a TS in application mode, but remote admin should be no problem.

Reinstalling the RDP client on the SQL server, or making connections to other machines wont have help in this case, because that is simply the client side of the communication process.  What you should be focusing on is Terminal Services on the SQL box.  Have you checked to see if the server is listening on port 3389 (use telnet on the client or Netstat -an on the console)?  This is the port that clients use to connect to a terminal server.  Perhaps try reinstalling the Terminal Services (remote admin mode) windows component.
0
 

Accepted Solution

by:
KNBsysteembeheer01 earned 0 total points
ID: 22685324
Well ron9909 I've found the solution:

Remote Desktop Stops Working After SQL Server 2005 Installation
Although, I have no idea why this happens, here is how to fix RDP/RDC connections after a SQL Server 2005 installation breaks it.
"      Control Panel > Administrative Tools > Terminal Services Configuration > Connections
"      Delete the RDP connection
"      Right-click Connections and select Create New Connection
"      Accept the wizards defaults
"      Name it RDP-tcp or something descriptive
"      Reboot, and youre back in business!
Unfortunately, the reboot is necessary.


0
 
LVL 2

Expert Comment

by:Ron9909
ID: 22693606
Ah - so the RDP listener has either been corrupted by the SQL 2005 installation, or the permissions have been modified.

That's one to file away for future reference!  Thanks for the update.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

##the calculator has been updated to version 1.6 please download the use the updated version## Hi there, After the previous post of the original version of the calculator here : http://www.experts-exchange.com/articles/OS/Microsoft_Operatin…
The environment that this is running in is SCCM 2007 R2 running on a Windows 2008 R2 server. The PXE Distribution point is running on its own Windows 2008 R2 box. This is what Event viewer showed after trying to start the WDS service:  An erro…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question