Thanks for that additional information. I will look into these possibilities and discuss with our security folks.

Mike, please help me understand why this is so, before I go to our security team. If I am able to connect from the same machine to the same machine...

Thank you for the suggestions. I am not using and SQL Alias; I'm using the server name (URI) and connecting over TCP/IP. The fact that I am able to connect...

No, I'm using OLE DB.

Here is the connection string that doesn't work on the live server:

Data Source={redacted};User ID={redacted};Initial Catalog=mu9165;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=False;Application Name=SSIS-Package1-{F2F7B6B9-9E6E-4EA5-9BD7-B3BE2C0E5C4B}{redacted};

Here's one from a package that works (for...

• This reply was modified 5 years ago by  Pete.

Thanks for that helpful response, Mike. It makes sense that it seems like a DNS or firewall issue between the local SQL Server and the remote one. So I tested...