okacs
asked on
Getting "The RPC Server is unavailable" errors when trying to connect to SSIS
We have a SQL 2005 Server on which we are having trouble connecting to SSIS. I can connect to the database engine and run queries just fine, but I can not connect to integration services. We've tried connecting from several PCs to no avail. The error that we are getting is:
"Failed to retrieve data for this request. (Microsoft.sqlserver.smoEn
The RPC Server is unavailable. (Exception from HRESULT: 0x800706BA)
(Microsoft.SQlServer.DTSRu
The RPC Server is unavailable. (Exception from HRESULT: 0x800706BA)
(Microsoft.SQlServer.DTSRu
The SQL server is behind an internal firewall, and ports 3882 and 135 are open from our source IPs. The firewall logs show attempted connections on odd ports like 3646 ?? Why would the ports be changing?
"Failed to retrieve data for this request. (Microsoft.sqlserver.smoEn
The RPC Server is unavailable. (Exception from HRESULT: 0x800706BA)
(Microsoft.SQlServer.DTSRu
The RPC Server is unavailable. (Exception from HRESULT: 0x800706BA)
(Microsoft.SQlServer.DTSRu
The SQL server is behind an internal firewall, and ports 3882 and 135 are open from our source IPs. The firewall logs show attempted connections on odd ports like 3646 ?? Why would the ports be changing?
SQL Broker Services trys to use other available ports.
Try setting the server name in your connection string to TCP:[IPADDRESS]:PORT
Try setting the server name in your connection string to TCP:[IPADDRESS]:PORT
Example:
TCP:192.168.1.99:1433
TCP:192.168.1.99:1433
ASKER
I tried that.
I get the error "Cannot connect to TCP:<ip address>:1433" "Connect to SSIS service on machine TCP:<ip address>:1433 failed. The RPC server is unavailable.
Tried this with and without the "TCP" and with several different ports that are all allowed in the FW rules.
Still can't connect.
I get the error "Cannot connect to TCP:<ip address>:1433" "Connect to SSIS service on machine TCP:<ip address>:1433 failed. The RPC server is unavailable.
Tried this with and without the "TCP" and with several different ports that are all allowed in the FW rules.
Still can't connect.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, I tried the above with using port 3883. I am still unable to connect unless I specifically open port 3436 in the firewall. <Sigh> Why does it want to use 3436???
ASKER
#$(*&^(*&$#%(*&$ ARGH !!!!!!!!
It was working fine with a port open for 3436 but now it wants to use port 2499!
I cant keep making Swiss-cheese out of my firewall!!!
HELP!!
ASKER
THIS PROBLEM WAS NOT RESOLVED, BUT THE QUESTION CANT REMAIN OPEN. ADMIN WANTS TO MARK IT ABANDON AND DELETE IT. :(
Banthor, thanks so much for all your help. I Will close the ticket award points for your assistance!
ASKER
I guess we didn't find an answer, but Thanks so much for all your help!
ASKER
Note: When I open port 3646 on the firewall, connections to SSIS work. But after about a month, it stops working. Checking the logs will reveal that SSIS connections have moved on to yet another port number again.... I cant keep swiss-cheesing my firewall for this!