Hi

What is the main objective you are trying to achieve with the overall process? This seems complicated for what I think you are trying to do.

If you cycled around the...

Jon.Morisi (3/24/2016)

---

What are you trying to do exactly?

Here's some related links:L

Windows Server: Troubleshooting "RPC Server Unavailable" Errors

Connecting to remote SQL Server Integration Service from SQL Server management Studio[/url]

RPC Service not...

Hi Brandie

When you are using MS SQL Server Management Studio, one of the options is to connect to the Integration Server. It is this that I was having problems with....

Hi Brandie

Yes, I can connect to the server if I want to connect to the database server using SSMS with no issues using the same admin credentials.

Thanks anyway

Rich

Hi

Just to add to Hugo's comment.

You could also look at the statistics to try and help understand the difference between queries (given they actually do give the same results).

I changed...

Hi

We have a secure network with vlans and multiple firewalls as well as the windows firewall on the servers. All I'm trying to do is connect to the integration server...