Our IIS Webserver and SQL server 2000 installed into two
machine and separate by a firewall.
Recently, I need to disable name-pipe protocol in our SQL
client of webserver. But the TCP/IP not work, even I
opened the port 1433 of this.
I've a test that I release all port for that and set the
client network setting to use TCP IP only. It still not
work.
Please help.
(P.S: if I added Name-pipe in network config. of client,
it request port 445 & 139 on the firewall. Is it correct
response? I afraid we are under attack)Things to test.
1. Can you make a tcp socket connection to the server inside the firewall?
Test with ISQL.
ISQL -Stcp:ServerNameHere -Uuser -Ppassword -Q"select @.@.version"
If it fails, search on the OS error returned.
Example:
10060 is connection timeout
10061 is the server is not listening on the socket.
11001 host not found
If it works inside the firewall, try the same on the machine outside the
firewall.
Check the firewall logs.
Or make simultaneous network traces on both the client and server when
running the ISQL command above.
Hope this helps.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment