PC Review


Reply
Thread Tools Rate Thread

Connection Problem VB.Net 2003 to SQL 2000

 
 
Fred
Guest
Posts: n/a
 
      6th Feb 2007
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

 
Reply With Quote
 
 
 
 
=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=
Guest
Posts: n/a
 
      6th Feb 2007
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


"Fred" wrote:

> 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
>
>

 
Reply With Quote
 
Fred
Guest
Posts: n/a
 
      6th Feb 2007
Kerry,

Thanks for your reply.

I have since discovered that this problem only occurs on Windows 2003
R2 (SP1) On a server running Windows 2003 without SP1 the problem is
not there. I guess the next step is to try and find out what (if
anything) has changed in SP1 that could cause the problem.

Regards

Fred

On 6 Feb, 13:58, Kerry Moorman
<KerryMoor...@discussions.microsoft.com> wrote:
> 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
>
>
>
> "Fred" wrote:
> > 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- Hide quoted text -

>
> - Show quoted text -



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 ADP and SQL 2000 db Server Connection =?Utf-8?B?RW1tYQ==?= Microsoft Access 1 30th Oct 2006 04:59 PM
Creating a connection to MSSQL 2000 on MS Server 2003 =?Utf-8?B?emVkNTAw?= Microsoft Frontpage 2 16th Mar 2006 09:24 AM
Access 2003 connection to SQL 2000 database Jamie Microsoft Access ADP SQL Server 3 8th Dec 2004 03:56 AM
OL 2003 drops connection to Exchange 2000 Bill Morano Microsoft Outlook 0 17th Sep 2004 11:00 PM
Problems with Outlook 2003 connection on Exchange 2000 Giliam N.S.S. Microsoft Outlook 0 15th Jul 2004 06:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:18 PM.