Remote Desktop | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Remote Desktop

I’m having an issue with one of my SQL 2K5 server. I’m trying to schedule my full-text catalog and I get SQL Server does not allow remote connection message. I checked the server and it is configured to allow remote connection for both TCP/IP and named pipes. I also checked and verified that the SQL Server Browser is running. Has anyone experienced this issue? I’m attaching a screen shot of the error message. Thank you for any input. Rinu
If it is named instance….try to pass the port number along with server name and instance name… ex: server1inst1,portnumber MohammedU.
Second time in this week with this issue. I had the same problem months ago. I fixed using Mohammed suggestion. Other way I found is using Client Network Configuration (2000 tools) but setting port dynamically. Luis Martin
Moderator All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Mohammed I am not sure about this , but is this issue related in any way to the entries in C:WINDOWSsystem32driversetchost file? Satya
No, I don’t think so…
where is the screenshot link!! if you have already access in past and if it is troubling you ensure you haven’t disabled/stop any servevices (RPC/Net DDE DDSM )!!! Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami and fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.