1. I have two Windows 2003 Standard Server boxes. 2. Both host MS/SQL Server Standard 2000. 3. Server#2 is linked to Server#1 using SQL/Enterprised Link Server applet. 4. Both servers have Win2k3 Service Pack#1 installed. 5. Both server enable firewall via SCW (Security Config. Wizard). I locked everything but SQL Server Port (1433). 6. Both use TCP/IP as top (default) network protocol. 7. All Windows XP clients can read/write to and from the two SQL servers without problem (Windows and SQL Auth. are used).
Problem: Server #2 cannot read data from Server#1 it links to. It said Sever#1 is not running or access denied. Even if SQL Ports on both boxes are widely openned. because clients from outside can get to it. Hopwever, if I disable firewall on Server# 1, then Server# 2 will be able to read data from #1. I really like the FW in service pack# 1. But if I have to disable it in order to use "Link Server" (server-to-server) in MS/SQL then this new thing (FW) in W2k3 is really useless ! Therefore I assume that I am missing something very important ?