Groups | Blog | Home
all groups > sql server connect > february 2007 >

sql server connect : Connection Problem VB.Net 2003 to SQL 2000


Fred
2/6/2007 5:20:03 AM
Hi,

I have a webservice created in VB.NET 2003 hosted on a Windows 2003
server. This service inserts data into a SQL Server 2000 database also
hosted on a Windows 2003 server. The webserver is in a closed DMZ and
the Database Sever is on the internal network. The firewall is
configured to allow traffic to the DB Server on port 1433. Form the
outside world the request get passed throught to the webserver as it
should be. However when the request from the webserver is passed to
the DB server the request on port 1433 is being passed but two
requests one on port 137 and one on port 445 are being dropped. Can
anyone tell me why a simple sqlCommand.ExecuteNonQuery() would need to
use 137 and 445?

Many thanks

Fred
Kerry Moorman
2/6/2007 5:58:00 AM
Fred,

These articles don't apply directly to your situation, but they do explain
those additional ports:

http://support.microsoft.com/kb/841251/

http://support.microsoft.com/kb/841249/

Kerry Moorman


[quoted text, click to view]
AddThis Social Bookmark Button