Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

cannot connect ot local

Posted on 2013-01-10
3
Medium Priority
?
370 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

618 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