Question Locked

RPC Server Unavailable

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Have 4 Windows Server 2003 SP2 machines all recently upgraded from SQL 2000 to SQL 2005. Can connect to SSIS on 3 out of 4. Can connect using WMI to 3 out of 4. 2 of 4 are exactly the same, one being the source and one the target in a disaster recovery situation. Of these two the one that can be connected to with WMI and SSIS is the target, but the source will not work. Keep getting "Win32: The RPC Server is Unavailable" message. Event log on target shows "DCOM was unable to communicate with the computer using any of the configrued protocols." SSIS just says "Access is Denied." DNS appears to be fine. Permissions, services, etc. all seem to be fine. Checked all DCOM settings, etc. between the 4 machines and they appear to all be the same, yet can't connect to the one machine. Any insight would be appreciated!

2 replies

by tony hopkinson

Windows Firewall on the server blocking inbound on the port. SQLBrowser being blocked or not running, and my favourite default on the server is not to allow TCP/IP connections.

SQLserver Managment Studio, The Config and Surface area tools should give you more clues.

This discussion is closed to new replies.