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 ).
"User Id=<id>;Password=<password> Catalog=<catalog>;Server=<servername>; Connection Timeout=120;"
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