Connection from asp.net application to SQL Server 2000 blocked byfirewall

Schalley Ben

Hi

First of all, this is my first post on a newsgroup so don't shoot me if
I ask this in the wrong place.

Here is the situation. I'm developing an asp.net application with access
to a SQL Server 2000 on the companies network. On my development machine
I have Bitdefender Internet Security v10 installed. With the Bitdefender
Firewall disabled I have no problems in surfing and debugging the
application. However when the firewall is enabled, it asks if I want to
allow aspnet_wp.exe to connect to the sql server and off course I allow
this. The rule that allows aspnet_wp.exe to connect to the sql server is
successfully added to the firewall but still the connection to the sql
server fails. I communicated this with Bitdefender support but they
haven't come up with a solution yet.

Today I tried adding a rule to the firewall manually. The rule I added
allows ALL applications on my machine to connect to the SQL Server by
its ip-address and port, communication is allowed in both directions for
TCP only. This firewall rule (in my eyes everything but secure) lets the
asp.net application successfully connect to the SQL Server. Now because
of this rule I added, I started wondering if there are other .net
processes which need permission to connect to the SQL Server for a
successful connection. At least the firewall does not inform me of other
processes which try to connect.

Is there anyone who can help me?

Best Regards
Greetz & Thanx

Ben Schalley

Oct 31 '06 #1

Subscribe Reply

1652

Nick Malik [Microsoft]

AFAIK, no other processes from your machine need to connect to SQL Server in
order to allow the management tools and the web app on your dev box to query
the database. You should be fine for this purpose.

There is probably a technet article on the ports needed by SQL Server.
Check out the technet library for detailed technical info.

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"Schalley Ben" <be**********@b isnet.bewrote in message
news:e3******** ******@TK2MSFTN GP03.phx.gbl...

Hi

First of all, this is my first post on a newsgroup so don't shoot me if I
ask this in the wrong place.

Here is the situation. I'm developing an asp.net application with access
to a SQL Server 2000 on the companies network. On my development machine I
have Bitdefender Internet Security v10 installed. With the Bitdefender
Firewall disabled I have no problems in surfing and debugging the
application. However when the firewall is enabled, it asks if I want to
allow aspnet_wp.exe to connect to the sql server and off course I allow
this. The rule that allows aspnet_wp.exe to connect to the sql server is
successfully added to the firewall but still the connection to the sql
server fails. I communicated this with Bitdefender support but they
haven't come up with a solution yet.

Today I tried adding a rule to the firewall manually. The rule I added
allows ALL applications on my machine to connect to the SQL Server by its
ip-address and port, communication is allowed in both directions for TCP
only. This firewall rule (in my eyes everything but secure) lets the
asp.net application successfully connect to the SQL Server. Now because of
this rule I added, I started wondering if there are other .net processes
which need permission to connect to the SQL Server for a successful
connection. At least the firewall does not inform me of other processes
which try to connect.

Is there anyone who can help me?

Best Regards
Greetz & Thanx

Ben Schalley

Nov 2 '06 #2

Similar topics

8000

multi-thread tasks using a single connection object concurrently

by: meng | last post by:

is it possible to use a single connection object shared by several tasks where each task is handled by a thread? these tasks call stored procedures that return record sets, no editing, update or delete. my objective is that db connection is expensive and each user can only have 1 connection object. each user submits a request to the web server, and the result web page construction consists of a number of result sets obtained from several...

Microsoft SQL Server

2386

connection problem to sql 2000 on windows 2003 from Windows 95

by: Marino | last post by:

Hi all, I have a Windows 2003 server, which is also a terminal server for application, with sql 2000 installed. My company has developed an application that uses SQL 2000 as its database. The application is a client/server one. In each client computer there's a link to the application on the server. There is no problem with Windows 98, Windows 2000 pro, Windows xp pro clients, but the windows 95 ones cannot log in to the database. The...

Microsoft SQL Server

1473

One ms sql server 2000 instance blocks the other (thru a dts-job)

by: juergen.simonsen | last post by:

Hello, we use two instances of the ms sql server 2000 (Version: 8.00.760) on a 4 processor windows 2000 (sp 4) machine. A dts-packet on one instance completly blocks the work on the other instance. Both instances have 2 dedicated processors. The two processors of the blocked instance are in idle states. How is this possible? Has someone had the same behavior of the sql server and found a solution for this problem?

Microsoft SQL Server

2283

Help me in Specifying Connection string to SQL server 2000 running on remote machine

by: vighnesh | last post by:

Hi All I am dealing a project in ASP.NET in which I have to establish a connection to SQL Server 2000 database,where the database was located on a remote system. For this I have used SQLConnection object and specified the connetion string.But when it comes to establish a connection its giving me the Error that I. Connection string : workstation id=localhost;packet size=4096;user

ASP.NET

16499

Underlying connection was closed

by: Rajeev Tipnis | last post by:

http://support.microsoft.com/default.aspx?scid=kb;en- us;819450 Questions: 1) Is this patch (fix) applicable to the .NET 1.1 Framework as well? That is, if we have Framework 1.1 (On Win2K3/IIS6.0), do we still need this patch? 2) Does it specifically solve only this error: The underlying connection was closed. An unexpected error

.NET Framework

8853

The underlying connection was closed: An unexpected error occurred

by: Fredrik L | last post by:

Hi, We have an application outside the firewall who talks to a webservice inside the firewall. 9 times of 10 this works, but sometimes we got the error "The underlying connection was closed: An unexpected error occurred on a receive." We have tested some of the solutions that we have found in this discussion group but the problem still exist. We use .NET Framework 1.1. The application server use Win2003. The webservice server use...

.NET Framework

8518

ASP.NET 2.0 and connection to remote SQL 2000 server

by: Mitya Mitriev | last post by:

Hi I created ASP.NET 2.0 web application that uses SQL Server 2000 database and it works perfectly when website and Sql server were on local machine. Then I installed application on production server. Database is placed on another server. I received the error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings...

ASP.NET

1867

Lock Problem and application is slowed down

by: laststubborn | last post by:

Dear Memebers, I have a critical problem. I have an application is running on 64 bit machine. It used to be running on 32 bit machine. That application is using a Stored Procedure that uses SELECT, INSERT, UPDATE statements. Whenever this applicataion is being run all the processes are locked and INSERTING operation becomes cumbersome. We tested again on 32 bit machine however it happened again. So what might be the problem? Can...

Microsoft SQL Server

2760

SQL Server 2000 - OLE DB string connection

by: borisding | last post by:

Hi all, I have recently migrated ASP application from Windows server 2000 to 2003. But failed to connect to SQL Server 2000. (Both sql server and application are on the same server) I keep getting this error message when trying to connect to SQL Server 2000 from application: Microsoft OLE DB Provider for SQL Server error '80004005' Specified SQL server not found.

ASP / Active Server Pages

8420

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8324

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8740

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8617

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7353

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6176

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5642

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4330

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1733

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General