asp.net ASP_WP.exe problem

[Nicolas]

Hi,
I was suffering for few days,
I has 1 asp.net application running in window xp.
the application is used for generate the reports.

The problem is,
when i try to run a report is open many connection, it will show the following error...
"An error has occurred while establishing a connection to the server. When connection to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - An operation on a socket could not be performed vecause the system lacked sufficient buffer space or because a queue was full.)"

when this problem occur, i need to open the task manager and end task the asp_wp.exe, else the whole application can't use, even i press F5 or close the IE and re-open again.

Some time the error message also will show "The sql server may not exist"

Anyone can help ....

Thanks

[kenobewan]

Have you checked you connection string? Does the sql server allow remote connections?

[Plater]

Does the report start out working and then eventually stop working?
Are you remembering to explicitly close all your connection and command and other sql objects?

[Nicolas]

@kenobewan
yes i checked already. is allow.
this problem occur while i try to generate a heavy reports.

[Nicolas]

@Plater
yes i checked all my code. i have close the connection after i use it.

[Plater]

The trial/free versions of SQL server have a max connection limit I think.
Maybe there is a setting like that somewhere that just needs to be "upped"

Do you have "Sql server manegement studio" (express or otherwise)? You can use it to see who is connected to the SQL server and what their last task was.
Maybe it can tell you something

[Nicolas]

@Plater
The SQL server is paid, not the free/trial version.
connection limit i also set to unlimited.
the qeury time out i also set to more long enought.

Actually i don't know the problem is occur in sql server or my asp.net application.

[Nicolas]

Anyone can help ..??

[Plater]

Have you checked the sql management software to see what the connections to the database are doing?
The first step might be to isolate if its the SQL side or the ASP.NET side