By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,825 Members | 1,258 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,825 IT Pros & Developers. It's quick & easy.

"SQL Server does not exist or access denied" & "Timeout expired"

P: 3
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!
Jul 26 '07 #1
Share this Question
Share on Google+
1 Reply


P: 10
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!
please check these step by step :
1-your Licence for sqlserver in your host(Number of concurrent user)
2-calculate your application resource used for these number of users and compare it with your host hardware resources.if your application server and database server runs in on server.your application maybe impact on your sqlserver services[related to share resources].
Jul 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.