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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ahmnasa
    New Member
    • Jul 2007
    • 3

    #1

    "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!
  • hoomaniraji
    New Member
    • Jul 2007
    • 10

    #2
    Originally posted by ahmnasa
    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].

    Comment

    Working...