?
Solved

cannot connect ot local

Posted on 2013-01-10
3
Medium Priority
?
369 Views
Last Modified: 2013-01-10
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?
0
Comment
Question by:LenTompkins
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
Gary Fuqua, CISSP earned 1500 total points
ID: 38765316
Are you trying to connect to a Local Copy of SQL Server, or over a LAN connection from a workstation to a server?

If over a LAN, verify that SQL Server is running on the server.   On the workstation, make sure that you don't have a firewall blocking access.   Some antivirus programs will change the firewall settings and cause problems when they are updated.   I suggest turning off any firewall or antivirus program for your testing.
0
 

Author Comment

by:LenTompkins
ID: 38765415
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.
0
 

Author Comment

by:LenTompkins
ID: 38765477
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.
0

Featured Post

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question