468,554 Members | 1,878 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,554 developers. It's quick & easy.

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

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
1 5508
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.

Similar topics

2 posts views Thread by Nils Magnus Englund | last post: by
3 posts views Thread by Nils Magnus Englund | last post: by
3 posts views Thread by Agnes | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.