Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2011
    Posts
    47

    Red face Unanswered: how to solve error 40 on MSSQL 2005 ?

    yesterday everything was set my application was running fine but suddenly at midnight the MSSQL 2005 server start giving me an error saying error 40
    Code:
    error 40  could not open a connection to SQL server
    so i have quickly search the net to solve this up and i got a blog which says go to your configuration manager and check whether MSSQL service is running , so i went there and check the service was not running so i started it, but it fails to start
    i have not changed anything and I m just connecting my application to the database and both are local (no remote connection at all)
    can any one explain me why this problem occurs and to be more specific how to solve this problem in couple of minutes because i hate that error message.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    what is in the SQL Server errorlog file?

  3. #3
    Join Date
    Sep 2011
    Posts
    47
    Quote Originally Posted by MCrowley View Post
    what is in the SQL Server errorlog file?
    thanks for the reply but that was my friends laptop and now i don't have it to check whats there in the log file
    cant you provide help with just the error message

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Sorry. My crystal ball is not working.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by navedjobs View Post
    thanks for the reply but that was my friends laptop and now i don't have it to check whats there in the log file
    cant you provide help with just the error message
    We are somewhat limited, because in order to help you resolve an error 40 where the SQL Server service does not start we need to see the errorlog file to determine what the problem/solution is.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  6. #6
    Join Date
    Feb 2012
    Posts
    12

    Could be anything

    -Is the disk out of space
    -did the password change for the account running sql server
    -did someone delete a file they weren't supposed to
    -did someone change the default database then drop it
    the list goes on, need those logs
    try using eventvwr.msc applicationm log you will see the event
    should give you a good idea as t o where to start

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •