LenTompkins
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER