For anyone who has tried all the troubleshooting helps without success.
This was my issue.
Changed the data source from a named server to the IP address and got through the firewall.
simkar
Last Activity: Sep 25 '08, 04:05 PM
Joined: Sep 24 '08
Location:
-
Named Pipes Provider, error 40 - Sql Exception (0x80131904)
Error:
provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
SqlException (0x80131904)
General Info:
Application is on server1(outside the firewall)
Database is on server2(inside the firewall) SQL Server 2005
Login is server authentication (Windows and Server Authentication is checked)
Remote server is allowed.
...
No activity results to display
Leave a comment: