Stupid question…. Is the SQL Server instance communicating using Named Pipes only, or TCP/IP as well?
On the firewall/router, you *should* only need to have TCP/1433 (someone please correct me if I have the port wrong, but I think that’s right) open to/from the SQL box. Also, you should probably make sure that your routes are set up properly; if the internal network doesn’t know how to get to the SQL box’s subnet and vice versa, that could be the problem.
Discuss This Question: 3  Replies