SQL connections stop & Webservices

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

SQL connections stop & Webservices

Author

Topic

Core
Starting Member

15 Posts

Posted - 2007-10-10 : 14:23:43

Hello, I appeal to all to save me from this situation.

I have a WebService in VB.net by IIS and a operation to connect to the SQL server and run a query and others operations. All fine...

But after a certain time only the SQL operations don't respond nothing, the others are OK. So the problem is not in the IIS i think and something between the IIS and the SQL Server.

Can you give me some light about this PLEASEEEE :D ?
Thanks

If any of you need the source say it.
Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-10 : 14:50:30

You haven't provided enough information for us to help.

Please explain in more detail what the following means:

quote:

But after a certain time only the SQL operations don't respond nothing, the others are OK.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Core
Starting Member

15 Posts

Posted - 2007-10-10 : 16:11:50

Per example, I have a operation that return a simple string, like this, I do a "ping" and the webservice return a "pong"...

Simple operation.. The problem remains, in the operations who return data who derived from a SQL Server.

After same time, I don't know how many requests , that operations just don't return nothing... Then i have to make a IISRESET to this operation and all return to normal.

The same operation who same time ago work just fine, just stop working. The only that stop are the one's realetad to the request by SQL Query.

This is happening on my machine with SQLExpress.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-10 : 16:14:13

If performing an iisreset fixes your problem, then the issue is not inside SQL Server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Core
Starting Member

15 Posts

Posted - 2007-10-10 : 17:02:04

But why the others operation all work..

The pages in the IIS etc. all things work..

Its something related to both servers don't you thing ?

Thanks..

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-10 : 22:59:31

What kind of connection between web server and sql server? Did you see any related error in web app log? You can also use profiler to trace if get any sql request from web app.

Core
Starting Member

15 Posts

Posted - 2007-10-11 : 13:59:02

Hey, give me some info to do so. Log's and Trace's

Here's my connection string:

connectionString = "server = " & strServer & ";Initial Catalog = " & strDataBase & ";"
"User ID = " & strDBUsername & ";Password = " & strDBPassword & ";"
'Conexão SQL
MySQLConnection = New SqlClient.SqlConnection(connectionString)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-11 : 23:51:04

Check sql books online on how to set trace with profiler, also check network traffic with network monitor.

Core
Starting Member

15 Posts

Posted - 2007-10-12 : 10:05:19

How will those profiles help to solve my question? What they do ?

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-13 : 00:17:34

It will tell you if client request ever reached sql server.