I have a website that has been running for over 1 year now that has never had these issues.
Its running MS SQL Server 2005 Express Edition and IIS6 ASP 3 coded. All running from one server.
I am starting to randomly get the following errors:
Microsoft OLE DB Provider for SQL Server error '80004005'
Timeout expired
and also
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
It only happens sometimes. When it occures, I can refresh the page and usually it would be ok again.
I am getting a lot of visitors to the website, around 7k uniques per day so I am guessing it is to do with the high demand and concurrent connections to the database.
Anyone have any ideas how to solve this issue.
Thanks!
Its running MS SQL Server 2005 Express Edition and IIS6 ASP 3 coded. All running from one server.
I am starting to randomly get the following errors:
Microsoft OLE DB Provider for SQL Server error '80004005'
Timeout expired
and also
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
It only happens sometimes. When it occures, I can refresh the page and usually it would be ok again.
I am getting a lot of visitors to the website, around 7k uniques per day so I am guessing it is to do with the high demand and concurrent connections to the database.
Anyone have any ideas how to solve this issue.
Thanks!
Comment