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