asked on

Database Connection Issue

WE have a website that is having issues connecting to a database on our server. Some days it works and some days users are not able to connect ( Timeout error ).

Connection String:

"User Id=<id>;Password=<password> Catalog=<catalog>;Server=<servername>; Connection Timeout=120;"

Open in new window

If I change server = "localhost" then I am able to connect to the server, but after a few days someone will complain they timeout again. In order to get the website to work, i have to keep changing the connection string ( server = servername or server = localhost ) when someone timesouts.

We haven't figured out what the problem is, so I came here looking for suggestions. My IT Director doesn't think it has anything to do with DNS.

A few comments:
- Website: ASP.NET 2008, Visual Basic
- Only around 5 employees access the website
- The problem usually is reported around the same time of day, but that could be that is the only time they use the program
- We have multiple websites/applications accessing the same server with no problems

ASKER CERTIFIED SOLUTION

Pavel Celba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

arnold

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Radhakrishnan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Mike Lazarus

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mmsi

ASKER

I'm going to have someone look into IIS to see if that is the problem. When the web app was first created I didn't have these issues but I think around the time we moved everything to a new server is when people started getting timeouts.

I'm closing this question for further investigation. Thank you for the replies.