Link to home
Start Free TrialLog in
Avatar of LenTompkins
LenTompkinsFlag for United States of America

asked on

cannot connect ot local

My copy of SQL Server 2008 has stopped working.  I have had it installed since August and use it every day.  All of a sudden when I started up the computer, I am getting a message stating that it can't open a connection to local.  error 40 - Could not open a connection to SQL Server.  Microsoft SQL Server, Error: 2
Am I going to have to reinstall SQL server or could there be another problem?  
I shut down the computer and restarted it and I received the same error.  

I had Windows Authentication and I switched it to SQL Server Authentication and I recieved the same result. Any thoughts?
ASKER CERTIFIED SOLUTION
Avatar of Gary Fuqua, CISSP
Gary Fuqua, CISSP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LenTompkins

ASKER

I am connecting to a local copy of SQL server, and I turned the internet off as well as Kaspersky and I still received the same error.
I just solved the problem.  I turned the machine off, made sure it was unplugged, and took the battery out.  Then I held the power button down for 60 seconds and put the battery back in.  I restarted the computer and started SQL Server and it now works.  I believe I have some hardware issues with this machine, so I will have to get it fixed.  Thank you for your suggestion.