SQL Server and ASP.net timeout problems

[Guest]

Group,

I have a Web application sitting on a staging server that is using SQL
Server 2000 as its data store, and I can run the application flawlessly.
Now, when I copy the project to my localhost and run the application, using
the same SQL Server, I keep on receiving a SQLException Timeout expired. Any
ideas how I can remedy this?

 

[Jeff Dillon]

Can you create a simpler application locally that works?

Does any of it work? Is it a connection timeout or query timeout?

Jeff

 

[Guest]

Even if I create another application trying to pull the information from the
same SQL Server I get the timeout exception when it goes to fill the DataSet
using the DataAdapter. Now, if I go and pull the information from my local
host SQL Server that has a copy of the staging SQL Server's data everything
works OK.

 

[Jeff Dillon]

How are you logging onto SQL Server in your app?

Can you return data via Query Analyzer ok using the same login?

Jeff

 

[Guest]

I am logging in using SQL Server authentication, and I can retrieve
information using SQL Query Analyzer.

 

[Jeff Dillon]

Did you try a "select * from authors" in the Pubs database?

Jeff

 

[Guest]

Yes I did, and I was able to retrieve all authors.

 

[Scott Allen]

Any chance there is some sort of firewall or proxy between your local
machine and the staging server?

 

[Guest]

I downloaded and installed SP2 a couple of days ago. Anyway, I opened up
port 1433 of the firewall, but I'm still running into the same problem.

 

[Jeff Dillon]

So, um..what's different then? Did you do some troubleshooting at this
point after you realized that Pubs works?

What could be different? Permissions for one thing. Also, run SQL Profiler
on the SQL box to verify what SQL is being passed.

Jeff